Skip to main content
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
subathra
Partner - Contributor III
Partner - Contributor III
Author

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

Anonymous
Not applicable

Hey Subathra,

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

subathra
Partner - Contributor III
Partner - Contributor III
Author

No aparna i can't able to solve the problem

Anonymous
Not applicable

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