topic Loading Named Tables from Excel ooxml in QlikView

Loading Named Tables from Excel ooxml

michael_anthony — Wed, 19 Mar 2014 03:46:07 GMT

I have a xlsx (xlsm) Excel file with named ranges that I want to load into Qlikview. In the older .xls as biff format I could use:

LOAD * From
[RoutePlan_Qlikview_Control_File.xls]
(biff, no labels, table is VIC_Territories);

where Vic_Territories is the named range.

I can't work out the equivalent command in the ooxml format to point to the named range. I can point to the whole sheet, but I only want to pick up the specific cells in the named range. Using Qlikview v10.

If I use the SQLTABLES; view against the Excel, the named ranges are listed.

Thanks,

Michael

Re: Loading Named Tables from Excel ooxml

pennetzdorfer — Mon, 13 Oct 2014 05:29:30 GMT

Anthony, could you solve that issue meanwhile? Would be really helpful, thanks!

Regards,

Florian

Re: Loading Named Tables from Excel ooxml

michael_anthony — Tue, 11 Nov 2014 00:22:50 GMT

Believe that you can do it, but have to use OLEDB drivers and treat the Excel file as a datasource. I didn't go down that path as I needed 64-bit OLEDB driver for Excel. But our infrastructure team only has Excel 32-bit installs so I couldn't get the right environment to test it.