This content has been marked as final. Show 2 replies
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
(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.