Multiple Excel files with different Sheet name in Qlik sense

[subathra]

Hi all,

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

[jonathandienst]

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

[subathra]

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

[Anonymous]

For each..next ‒ Qlik Sense

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

[luismadriz]

Hi,

Have you tried something like this??

Load ...

from

FROM [folder/expense_*.xlsx]

(ooxml, embedded labels);

[subathra]

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

[subathra]

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

[Anonymous]

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

[subathra]

Hi aparna,

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

[subathra]

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