3 Replies Latest reply: Jul 17, 2015 8:45 PM by Nicolas ALLANO RSS

    Script to pull data with structured references from Excel table

      Hello,

       

      I have one Excel sheet which has several Tables (new functionality introduced in Excel 2007)

      Use structured references in Excel table formulas

      Capture.PNG

      Excel Tables do not seem to be directly available from QV script (ex: Design or Index)

       

      But Name Formula are instead available in QV, and then

       

      • I can pull the data from Design_FixedRange_Sheet, refering to  "=Data!$B$2:$D$8"

      TEST1.png

      • But not from Design_Table_Workbook or Design_Table_Sheet which refer to "=Design[[#Headers],[#Data]]"

      TEST2.png

      How can I pull the data using Excel table formula? As it is much more handy. Target is to have an many Tables under the same Excel sheet and user should be able to add lines with no need to update the name formula.