Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajayagraa
Contributor
Contributor

How can i load excel file with multiple sheets ?

Hi all

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

waiting to your reply

5 Replies
advait_thakur
Creator III
Creator III

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

Join the official Qlik Enthusiast's page here
https://www.linkedin.com/groups/6513382/
ajayagraa
Contributor
Contributor
Author

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

advait_thakur
Creator III
Creator III

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

Join the official Qlik Enthusiast's page here
https://www.linkedin.com/groups/6513382/
ajayagraa
Contributor
Contributor
Author

Thanks Advait

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

Not applicable

Please see this discussion

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

Regards

Mhatim