topic Re: Multiple Excel files with different Sheet name in Qlik sense in App Development

Multiple Excel files with different Sheet name in Qlik sense

subathra — Mon, 11 Dec 2017 12:47:53 GMT

Hi all,

I wanted to know that how to load multiple excel files with different sheet name in Qlik sense

Re: Multiple Excel files with different Sheet name in Qlik sense

jonathandienst — Mon, 11 Dec 2017 13:20:10 GMT

You would probably get more responses with more information.

Describe the file names and their location (all in a single folder, in a recursive tree, etc)
Are the sheet names known or must they be read from the file?
Do the sheets all contain the same information or loaded into the same target table?
etc

Re: Multiple Excel files with different Sheet name in Qlik sense

subathra — Tue, 12 Dec 2017 04:36:49 GMT

Hi jonathan,

1)File names are in same folder(Ex: Expense(folder),expense_Apr2017,expense_May2016(Excel filename))

2)for Excel expense_May2016 sheetname are A,B,C,D

for Excel expense_Apr2017 sheetname are A,B,C,E,F

(Excel Sheetnames are not known..it should load dynamically)

3)All the sheets contain same information

Re: Multiple Excel files with different Sheet name in Qlik sense

Anonymous — Tue, 12 Dec 2017 05:14:04 GMT

For each..next ‒ Qlik Sense

It may help you but change the code according to your requirements.

Re: Multiple Excel files with different Sheet name in Qlik sense

luismadriz — Tue, 12 Dec 2017 05:34:31 GMT

Hi,

Have you tried something like this??

Load ...

from

FROM [folder/expense_*.xlsx]

(ooxml, embedded labels);

Re: Multiple Excel files with different Sheet name in Qlik sense

subathra — Wed, 13 Dec 2017 04:47:26 GMT

Hi,

Ya i tried this..I list the available sheetnames in excel & used for loop to get all sheet names ..but while loading the excel file Excel expense_May2016 i get error msg like Sheet name E & F not found..similarly while loading the excel file Excel expense_Apr2017 i get error msg like Sheet name D not found..Is there any other to solve this issue

Re: Multiple Excel files with different Sheet name in Qlik sense

subathra — Wed, 13 Dec 2017 04:51:40 GMT

I also tried using ODBC Connectivity to get the sheetnames dynamically like Qlikview..but while using ODBC connect 32 to [...] i got error message like u cant connect to ODBC..u can only use lib file

Re: Multiple Excel files with different Sheet name in Qlik sense

Anonymous — Wed, 13 Dec 2017 04:53:43 GMT

In Qlik Sense, you have to create a new connection for ODBC, and specify path for folder.

Go to Create New Connection and ODBC connector and specify path

Re: Multiple Excel files with different Sheet name in Qlik sense

subathra — Wed, 13 Dec 2017 04:58:09 GMT

Hi aparna,

i created ODBC connection ...after that i insert the connection string into the application..

Re: Multiple Excel files with different Sheet name in Qlik sense

subathra — Wed, 13 Dec 2017 04:58:48 GMT

but i cannot use ODBC connect 32 to [..] in qliksense like Qlikview

Re: Multiple Excel files with different Sheet name in Qlik sense

subathra — Wed, 20 Dec 2017 05:26:53 GMT

Hi,

I loaded multiple excel files with different sheetnames using loop...while executing the above example if search for Sheetname E,F in expense_May2016 excel and shows error..is there any way to come out of loop if the sheet is not present

Re: Multiple Excel files with different Sheet name in Qlik sense

Anonymous — Wed, 20 Dec 2017 11:09:23 GMT

Hey Subathra,

were you able to solve the problem of loading dynamic sheet names?

Re: Multiple Excel files with different Sheet name in Qlik sense

subathra — Thu, 21 Dec 2017 04:32:35 GMT

No aparna i can't able to solve the problem

Re: Multiple Excel files with different Sheet name in Qlik sense

Anonymous — Fri, 22 Dec 2017 04:50:01 GMT

Even I'am facing same problem.Can you please post the script you are using?