last column table pivot

[ict@sogedin.it]

Hi, is possibile know the number of last column
in a pivot ??
(i want hidden last column in a pivot)

[Gary.zhang]

Hello,

Thans for your inquiry.
We will investigate and update to you ASAP.
Sincerely,
Gary
E-iceblue support team

[Gary.zhang]

Hello,

Thanks for your waiting.
Please try the following method.

Code: Select all

Workbook workbook = new Workbook();
workbook.LoadFromFile( "pt.xlsx");
Worksheet sheet = workbook.Worksheets["Pivot Table"];
CellRange cr = sheet.PivotTables[0].Location;
sheet.HideColumn(cr.LastColumn);
workbook.SaveToFile("Ptresult.xlsx",ExcelVersion.Version2010);


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

[Gary.zhang]

Hello,

Has the issue been resolved? Could you please give us some feedback if convenience?

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

Thanks,
Gary
E-iceblue support team