Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to load excel files having different format eg. Biff, ooxml dynamically

Hey All,

I have a scenario in which i get my data in the form of excel files from some source. But it is not sure whether i will get those excel files in 'Biff' or 'Ooxml'

format. So is there any way to make it dynamic so that whatever format comes, it would be able to handle it.

Regards,

Neelam 

2 Replies
prieper
Honored Contributor II

Re: How to load excel files having different format eg. Biff, ooxml dynamically

Can you differentiate by the extension, i.e. .xls or .xlsx?

Peter

Not applicable

Re: How to load excel files having different format eg. Biff, ooxml dynamically

Hey,

Actually I am not getting the way to fetch extension '.xls' or '.xlsx' from the excel file.

Can you please suggest some.

Regards,

Neelam