2 Replies Latest reply: Nov 10, 2014 7:22 PM by Michael Anthony RSS

    Loading Named Tables from Excel ooxml

    Michael Anthony

      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.