Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Fetching Data from Excel which has multiple Tabs

Hi All,

I am new to QlikView. I am trying to fetch data from an excel sheet which has multiple Tabs. Please let me know how to do that.

Thanks

2 Replies
er_mohit
Master II
Master II

go to edit script -->table files-->click on table file choose your excel file which have multiple tabs-->then on the top you will see Tables and there iyou see dropdown functionality  when you clik on it you ll see the other excel file tabs

hope it helps

if you don't want this statrted wizard then try this

in setting menu--->user prefrence--> in general tab---> on right side uncheck the show"Getting Statrted Wizard" when creating new document then ok...

close the qvw application and then open it doesn't come again

if it helps you then mark it as correct answer so, it miht be helpful for other developer

Not applicable
Author

when I select my excel file there in the file wizard, it says "The Excel file cant be read because it is encrypted'