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, nolabels, tableis 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.
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.