topic Re: Load Multiple excel sheets in QlikView

Load Multiple excel sheets

rkspareek1992 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 22 Apr 2019 12:29:05 GMT

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

rkspareek1992 — Mon, 22 Apr 2019 12:34:20 GMT

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

Vegar — Mon, 22 Apr 2019 12:49:49 GMT

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.