How to pick data from multiple excel sheet automatically.

[lalitkgehlot89]

Hi,

In Attached sample data file I want to pick all the data from all sheet of the excel.

But my no of sheet is not defined. It could be increased in future. but data format will be the same on all sheet.

Please let me know how to pic all the data with sheet name as column in data.

Thanks,

Lalit Kumar

[m_woolf]

https://www.qlikviewaddict.com/2012/03/looping-through-excel-sheets.html

[lalitkgehlot89]

Hi MW,

It is not working. Please check in attached QVW.

[m_woolf]

The qvw won't do any good without the excel workbook to load.

[lalitkgehlot89]

ok, Please get the both QVW and excel data file.

Please help me out to write the logic.

[m_woolf]

This worked for me.