| || |
Import Export file information
I would like to do the following:
1) Import data from an Excel spreadsheet. At this point I am importing to the Global sheet.
2) For each line, do some process (which I have recorded) and then record a static variable(Complete/Not Complete) back out to another spreadsheet.
I can do the import and I can export back out in bulk, but would like to be able to export on a Line-by-Line basis in case my script fails.
That way if my script stops, I can see what line it failed out.
Re: Import Export file information
You will get the effect you are after by updating a line and then re-exporting the entire file on each iteration through your test.