Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
subathra
Partner - Contributor III
Partner - Contributor III

Multiple Excel files with different Sheet name in Qlik sense

Hi all,

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

13 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
subathra
Partner - Contributor III
Partner - Contributor III
Author

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
Not applicable

For each..next ‒ Qlik Sense

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

luismadriz
Specialist
Specialist

Hi,

Have you tried something like this??

Load ...

from

FROM [folder/expense_*.xlsx]

(ooxml, embedded labels);

subathra
Partner - Contributor III
Partner - Contributor III
Author

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
Partner - Contributor III
Partner - Contributor III
Author

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
Not applicable

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
Partner - Contributor III
Partner - Contributor III
Author

Hi aparna,

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

subathra
Partner - Contributor III
Partner - Contributor III
Author

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