Qlik Community

Qlik Sense App Development

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

subathra
New Contributor II

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

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

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
New Contributor II

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

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
Contributor II

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

For each..next ‒ Qlik Sense

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

luismadriz
Valued Contributor

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

Hi,

Have you tried something like this??

Load ...

from

FROM [folder/expense_*.xlsx]

(ooxml, embedded labels);

subathra
New Contributor II

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

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
New Contributor II

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

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
Contributor II

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

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
New Contributor II

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

Hi aparna,

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

subathra
New Contributor II

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

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

Community Browser