Parse an EXCEL file into a Text file
Posted: Wed Nov 05, 2008 2:31 am
Hello.
Here is the scenario:
Cell A1
Cell B1
Cell C1
=> Loop
Cell A2
Cell B2
Cell C2
=> Loop
...
Each value then has to be stored in a text file as per below sample:
XXX'Cell A1'XXXXXXXXX'CellB1'XXXXXX.
XXXXXXXXXXXX'CellC1'XXXXXX.
...
I would like to use this task to parse the contents of some Excel files into 'UN/EDIFACT' files.
Many thanks for your help !
Here is the scenario:
Cell A1
Cell B1
Cell C1
=> Loop
Cell A2
Cell B2
Cell C2
=> Loop
...
Each value then has to be stored in a text file as per below sample:
XXX'Cell A1'XXXXXXXXX'CellB1'XXXXXX.
XXXXXXXXXXXX'CellC1'XXXXXX.
...
I would like to use this task to parse the contents of some Excel files into 'UN/EDIFACT' files.
Many thanks for your help !