pivot

[ict@sogedin.it]

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

[Annika.Zhou]

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

[Annika.Zhou]

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