Import excel more sheet - Song Nghia - Technical Consultant

Dynamic 365 FO Dynamic 365 Retail

Thứ Hai, 28 tháng 5, 2018

Import excel more sheet

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.