Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
michael_anthony
Contributor 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
Contributor III

Re: Loading Named Tables from Excel ooxml

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

Regards,

Florian

michael_anthony
Contributor II

Re: Loading Named Tables from Excel ooxml

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.

Community Browser