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.

Fri Feb 13, 2015 5:05 pm

Hi is possibile
this colunm:

PivotField r3 = pt.PivotFields["desora"] as PivotField;
r3.Axis = AxisTypes.Row;
r3.Subtotals = SubtotalTypes.None;
pt.Options.RowHeaderCaption = "ora";

not visible in pivot ??
thanks

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

Mon Feb 16, 2015 8:03 am

Hello,

Thanks for your inquiry. You could try to set the IsShowAllItems property of PivotField as false for your need.

Thanks,
Gary
E-iceblue support team
User avatar

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

Return to Spire.XLS