Multiple Excel sheet Load in QlikSense without changing the StandardReload to 0

rabbani_sk — Sat, 16 Nov 2024 04:05:03 GMT

Hi Folks,

I have tried few scripts which are available in QlikCimmunity nothing got worked out on

"Loading multiple Excel sheets dynamically in QlikSense".

Kindly share your thoughts or suggest some ideas. Thanks in advance!

Re: Multiple Excel sheet Load in QlikSense without changing the StandardReload to 0

Oleg_Troyansky — Tue, 19 Nov 2019 21:15:31 GMT

Hi there!

In a nutshell, you need to obtain an ODBC connector for Excel, then connect to your Excel document as if it was a database, using the ODBC connector, and use the command SQLTABLES to get the list of all tables in your spreadsheets (worksheets will appear as "tables").

Then, you can run through the list of "tables" in a loop and load each "table" in a usual way, as you always load Excel spreadsheets, replacing the Worksheet name with the "table" name that you received from SQLTABLES.

I'm showing a very similar example in my book (see below), even though it's not about Excel, but the logic is practically the same.

Cheers!

topic Re: Multiple Excel sheet Load in QlikSense without changing the StandardReload to 0 in App Development

Multiple Excel sheet Load in QlikSense without changing the StandardReload to 0

Re: Multiple Excel sheet Load in QlikSense without changing the StandardReload to 0