Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Anthony, could you solve that issue meanwhile? Would be really helpful, thanks!
Regards,
Florian
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.