Excel Sheets in load script

[didierodayo]

Hello,

I need some help with this scenario, the attached excel file has 2 sheets with the same columns . the sheet names are

city1_Sales    and    city2_Sales

I would like to read the content of both sheets in the same load script . How can this be achieved?

Thanks

[rahulpawarb]

Hello Didier,

I have created sample application as per your requirement. Please refer the same in attachment.

P.S.: I have created excel macro to populate the sheet names in first sheet. Once your add new sheet to the report then run the macro to get the latest sheet names.

Regards!

Rahul