topic Loading Excel Binary File into Qlikview. in QlikView

Loading Excel Binary File into Qlikview.

kaushiknsolanki — Fri, 25 Mar 2011 07:05:22 GMT

Hi Everyone,

I want to know Whether it is possible to load data from Excel Binary Worksheet which has .xlsb File format, into QlikView...

If it is possible please let me know the way in which it can be achieved....

Thanks..

Loading Excel Binary File into Qlikview.

Fri, 25 Mar 2011 07:45:17 GMT

It is possible by creating a new ODBC connection, using "Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)", to the file. Then using that ODBC-connection in QlikView.

Loading Excel Binary File into Qlikview.

kaushiknsolanki — Fri, 25 Mar 2011 11:21:09 GMT

Thanks Robin for your quick and valuable help..

Re: Loading Excel Binary File into Qlikview.

manojkulkarni — Wed, 27 Sep 2017 07:26:44 GMT

Hi Kaushik,

How do you handle if Excel drivers not installed ? Normally in production architecture Office will not be available in server ?

Re: Loading Excel Binary File into Qlikview.

marcus_sommer — Wed, 27 Sep 2017 08:21:56 GMT

Maybe you could outsource this job to another machine/system whereby why not installing office/excel or at least the database-driver (I could imagine that they are independently available)?

Of course I have heard statements from the IT guys that "a server is a server and no office belonged to them" but in my opnion it's not very responsible and cooperative - it's just a normal business requirement and from a security point of view no special risk especially compared with normal challenges to secure the environment.

- Marcus