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
      [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