Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
michael_anthony
Creator II
Creator II

Loading Named Tables from Excel ooxml

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

2 Replies
pennetzdorfer
Creator III
Creator III

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

Regards,

Florian

michael_anthony
Creator II
Creator II
Author

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.