Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
subathra
Partner
Partner

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
Partner

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
Partner
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

qlik_aparnav
Creator II
Creator II

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
Partner
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
Partner
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

qlik_aparnav
Creator II
Creator II

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

Hi aparna,

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

subathra
Partner
Partner
Author

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