topic Read xlsb file in Qlik Sense in Connectivity & Data Prep

Read xlsb file in Qlik Sense

Mauritz_SA — Thu, 14 Nov 2019 06:54:56 GMT

Hi everyone

We have a requirement to analyse files which are in xlsb format in Qlik Sense. I have seen a few posts where it can be done with QlikView, but none in Qlik Sense.

Has anyone perhaps done it?

Regards,

Mauritz

@rwunderlich , is this perhaps something that can be done using a SSE and Python?

Re: Read xlsb file in Qlik Sense

martinpohl — Thu, 14 Nov 2019 08:43:30 GMT

Hello Mauritz,

you can load datas is you are using a ODBC Connection to xlsb.

Then you can load the datas

Regards

Re: Read xlsb file in Qlik Sense

Mauritz_SA — Thu, 14 Nov 2019 09:41:10 GMT

Thanks Martin - works like a charm.

It would have been ideal to be able to specify the path dynamically (rather than an absolute path), but for now this solves the problem.