Yes, the TableEditor.tpl file is the file that I have suggested that you %include after adding the ODS PATH statement. After you have done this, you can then update an existing file which Excel can read such as an XML file with a pivot table by using the options OUTPUT_TYPE="script" which will generate a script file that will be executed at the end of the step. The UPDATE_TARGET="target workbook" is used to update the workbook with the pivot tables. You will also need to specify the sheet name of where we will get the columns using the SHEET_NAME= option. The last step is to execute the script which is done with the X statement in the code.
... View more