Loding Multiple cross tables from Muultiple Sheets of Excel

[ramyasaiqv]

Hello Community,

I’m trying to load multiple cross tables (Same fields just different years data) from multiple sheets of an excel and had no success. I did lot of research in the forum still I’m not able to resolve my issue. So I’m here for help please help me.

Attached script is working if I load year by year but I want to load all the sheets at a time as I want to make it dynamic.

I have attached the qvw I was working and also attached the sample excel with 2 sheets (2016 and 2017) data. Please help in trouble shooting the issue or please suggest if there a better way of doing it. Thank you,

Ramya

[ramyasaiqv]

Any help or suggestions please?

Thank you,

Ramya

[danistontt]

Hi Ramya,

have you tried this?

Load Multiple excel sheets using For loop

Daniele

[ramyasaiqv · Accepted solution]

Daniele,

I tried and it didn't work for my requirement. i figured out another way to solve my issue.Thank you,

Ramya