topic Re: How can i load excel file with multiple sheets ? in QlikView

How can i load excel file with multiple sheets ?

ajayagraa — Thu, 23 Aug 2012 10:59:41 GMT

Hi all

Can any one tell me how can i load a excel file with multiple sheets in qlik view

waiting to your reply

Re: How can i load excel file with multiple sheets ?

advait_thakur — Thu, 23 Aug 2012 11:03:39 GMT

Hello,

After clicking on Table Files > choose your excel from browse and then File Wizard window Click on drop down Tables. Here you will see the list of sheets available in your excel.

Thanks,

Advait

Re: How can i load excel file with multiple sheets ?

ajayagraa — Thu, 23 Aug 2012 11:18:40 GMT

that i knew i want to load all sheet in one reload how can i do that ?

Re: How can i load excel file with multiple sheets ?

advait_thakur — Thu, 23 Aug 2012 11:22:24 GMT

Hello,

There is no other option available in Qlikview then. I don't know may be Macro might work out in your scenario.

But at once you cannot load all sheets in Qlikview.

Suggestion: If possible and if suits your environment then please treat each sheet as a excel.

Thanks,

Advait

Re: How can i load excel file with multiple sheets ?

ajayagraa — Thu, 23 Aug 2012 11:25:08 GMT

Thanks Advait

But there is way to load all sheets data that i know anyways thanks a lot

Re: How can i load excel file with multiple sheets ?

Thu, 23 Aug 2012 11:33:50 GMT

Please see this discussion

http://community.qlik.com/message/195769#195769

Regards

Mhatim