Export Pivot Table to Excel

69 views

Skip to first unread message

unread,

Aug 30, 2016, 11:28:33 AM8/30/16

to AIMMS - The Modeling System

Hi,

Is it possible to export a pivot table to Excel without just copying it? For example to weekly export a pivot table for creating back up data?

Kind regards Lars

unread,

Sep 1, 2016, 10:57:58 AM9/1/16

to AIMMS - The Modeling System

Yes, it is possible. I just found out:

It is possible with an procedure and by giving the table a tag name in properties->misc.->tag name

PageCopyTableToExcel(

pageName: "TypeYourPageNameHere",

tag: "TypeYourTableTagHere",

IncludeHeaders: 1,

ExcelWorkbook: "TypeYourExcelWorkBookNameHere",

selectionOnly: 0,

Range: "A1",

Sheet: "TypeYourSheetNameHere"

)

Reply all

Reply to author

Forward

0 new messages