topic Re: Fetching Data from Excel which has multiple Tabs in QlikView

Fetching Data from Excel which has multiple Tabs

Thu, 07 Mar 2013 09:16:11 GMT

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

Re: Fetching Data from Excel which has multiple Tabs

er_mohit — Thu, 07 Mar 2013 09:52:15 GMT

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

Re: Fetching Data from Excel which has multiple Tabs

Thu, 07 Mar 2013 13:27:00 GMT

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