Load Multiple excel sheets

[rkspareek1992]

Hi,

I have an excel file which consists of many sheets. But I want to fetch only the sheets which starts from 'L *'.

For example sheet names are: 

Sheet Name

L ABC

L DEF

L POI

DEF

ABC

But I want to fetch only the sheets which starts from "L *" green colored.

Kindly suggest how to apply for loop or any other logic.

[m_woolf]

With this script, you should be able to and an IF condition to the vSheetName variable:

https://community.qlik.com/t5/QlikView-Documents/Dynamically-Loading-Multiple-Excel-Files/ta-p/14790...

[rkspareek1992]

I have already read this.. but unable to found solution.

[Vegar]

That linked solution is the way to go if you want to loop dynamically.

You need to have the Microsoft odbc connector to excel in order to get that linked solution to work.