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.

Thu Apr 22, 2021 10:51 am

Hi in pivot after or before this comand
pt.BuiltInStyle = PivotBuiltInStyles.PivotStyleMedium10;
is possible apply font size = 8 all pivot ??

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

Fri Apr 23, 2021 6:55 am

Hello,

Thank you for your inquiry.
Our spire.XLS supports customizing a pivot styles and defining the font size as follows. If there is any question, please feel free to write back.
Code: Select all
            string styleName = "newone";
            pt.CustomTableStyleName = styleName;
            PivotTableStyle pivotTableStyle = new PivotTableStyle(styleName);
            PivotStyle pivotStyle = workbook.CreatePivotStyle();
            pivotStyle.Font.Size = 8f;
            pivotTableStyle.Styles.Add(PivotTableElement.wholeTable, pivotStyle);
            workbook.AddPivotTableStyle(pivotTableStyle);


Sincerely,
Annika
E-iceblue support team
User avatar

Annika.Zhou
 
Posts: 1643
Joined: Wed Apr 07, 2021 2:50 am

Wed Apr 28, 2021 7:38 am

Hi,

Greetings from e-iceblue.
How is your issue going? Did the methods we provided help you? Can you give us some feedback at your convenience? Thanks in advance.

Sincerely,
Annika
E-iceblue support team
User avatar

Annika.Zhou
 
Posts: 1643
Joined: Wed Apr 07, 2021 2:50 am

Return to Spire.XLS