I guess, you didn't help yourself with testing with a huge block.
I suggest writing a test Job to check a very small Excel file 2 Sheets, just 2-3 columns with 2-3 records. Try reading and info them.
Also, use same variables
workbook = workbooks.item(1);
worksheets = workbook.worksheets();
worksheet = worksheets.itemFromNum(1);
//TODO: Read first sheet
worksheet = worksheets.itemFromNum(2);
//TODO: Read second sheet
Once you get this working, build your real data / file from there.
No comments:
Post a Comment