Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Sun Apr 06, 2014 3:07 pm

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

ict@sogedin.it
 
Posts: 63
Joined: Mon Jul 15, 2013 2:06 pm

Mon Apr 07, 2014 9:44 am

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
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Tue Jun 17, 2014 12:50 am

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?

jouji_s
 
Posts: 6
Joined: Fri Mar 07, 2014 6:22 pm

Tue Jun 17, 2014 7:21 am

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
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Tue Jun 17, 2014 12:56 pm

Clipboard.jpg
Clipboard.jpg (22.41 KiB) Viewed 3258 times


I would like to close detail like Desc1-Desc3.

Please let me know hot to do this.

Thanks.

jouji_s
 
Posts: 6
Joined: Fri Mar 07, 2014 6:22 pm

Wed Jun 18, 2014 8:16 am

Hello,

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

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Thu Jul 24, 2014 1:41 am

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
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Return to Spire.XLS