pivot hide detail

[ict@sogedin.it]

Hi. how can I hide a column in pivot detail ??

[Gary.zhang]

Hello,

Thanks for your inquiry.

Sorry that at present it is not supported.

If there are any questions, welcome to get it back to us.

Sincerely,
Gary
E-iceblue support team

[jouji_s]

Please let me know what means the detail.

I would like to set the closed "Row Labels".
I think it always opens by default.

Could you let me know about this?

[Gary.zhang]

Hello,

Thanks for your inquiry.
Sorry that we don't quite understand how you want to set "Row Labels", please create a sample input and output workbooks manually using Ms-Excel and attach them here, we will see how to achieve.

Thanks,
Gary
E-iceblue support team

[jouji_s]

Clipboard.jpg (22.41 KiB) Viewed 3350 times

I would like to close detail like Desc1-Desc3.

Please let me know hot to do this.

Thanks.

[Gary.zhang]

Hello,

Thanks, but sorry that currectly our product doesn't support the feature.

Sincerely,
Gary
E-iceblue support team

[Gary.zhang]

Hello,

Now our product can support the feature, and the newest hotfix has been released, you could download Spire.XLS Pack Hotfix Version:7.5.5 and refer the below method.

Code: Select all

Workbook book = new Workbook();
book.LoadFromFile("test.xlsx");
Worksheet sheet = book.Worksheets["Pivot Table"];
Spire.Xls.Core.Spreadsheet.PivotTables.XlsPivotTable pivotTable = sheet.PivotTables[0] as Spire.Xls.Core.Spreadsheet.PivotTables.XlsPivotTable;
pivotTable.CalculateData();
(pivotTable.PivotFields["Rollup1"] as Spire.Xls.Core.Spreadsheet.PivotTables.XlsPivotField).HideItemDetail("Buenos Aires", true);
book.SaveToFile("result.xlsx",ExcelVersion.Version2007);


If there are any questions, welcome to get it back to us.
Sincerely,
Gary
E-iceblue support team