Parse an EXCEL file into a Text file

Discuss RoboTask here
Post Reply
Gekseppe
Posts: 16
Joined: Tue Sep 02, 2008 4:45 am
Location: Iceland

Parse an EXCEL file into a Text file

Post by Gekseppe »

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 !
Post Reply