Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
rkspareek1992
Partner - Creator
Partner - Creator

Load Multiple excel sheets

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.

3 Replies
m_woolf
Master II
Master II

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
Partner - Creator
Partner - Creator
Author

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

 

Vegar
MVP
MVP

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.