Hide expand/collapse button in pivot table

[tatijana.jankovic]

Is there an option in Spire.Xls API to hide expand/collapse buttons in pivot tables? I am trying to generate excel using tamplate, that already contains pivot tables. In template, pivot tables don't have option Show expand/collapse button set. After I load template, I'm using Spire API to populate Worksheet, that is used as Data source for pivot tables. In generated excel, pivot tables have overriden option Show expand/collapse button set to true. (I would like, to remain false)

[Lisa.Li]

Hello,

Thanks for your inquiry.
Please refer to the following sample code to hide expand/collapse button in pivot table, if there is any question, just feel free to write back.

Code: Select all

Workbook workbook = new Workbook();
workbook.LoadFromFile(@"Sample.xlsx");
Worksheet sheet = workbook.Worksheets[0];
// Access the PivotTable
XlsPivotTable pt = sheet.PivotTables[0] as XlsPivotTable;
// Access the data field.
PivotDataField pivotDataField = pt.DataFields[0];
//hide expand/collapse button in pivot table
pt.Options.ShowDrillIndicators = false;
workbook.SaveToFile("result.xlsx", ExcelVersion.Version2013);


Sincerely,
Lisa
E-iceblue support team