Hi ,
Anyone please Help
1)How to set Layout to "Classic Pivot Table Layout".
2)How to set All column width to AutoFit.
3)And How to set Border for Pivot Table
I have tried all possible ways but not able to get suitable result.
Thanks in Advance
//1.set Classic Pivot Table Layout
pt.Options.ShowGridDropZone = true;
pt.Options.RowLayout = PivotTableLayoutType.Tabular;
//2.autofit columns generated by the pivot table
pt.CalculateData();
sheet.AutoFitColumn(1);
//3.custom the style of border
string styleName = "ptborder";
pt.CustomTableStyleName = styleName;
PivotTableStyle pivotTableStyle = new PivotTableStyle(styleName);
PivotStyle pivotStyle = workbook.CreatePivotStyle();
pivotStyle.Borders[BordersLineType.EdgeLeft].Color = Color.Blue;
pivotStyle.Borders[BordersLineType.EdgeLeft].LineStyle = LineStyleType.Thin;
pivotStyle.Borders[BordersLineType.EdgeRight].Color = Color.Red;
pivotStyle.Borders[BordersLineType.EdgeTop].Color = Color.Red;
pivotStyle.Borders[BordersLineType.EdgeBottom].Color = Color.Red;
pivotStyle.Borders[BordersLineType.EdgeBottom].LineStyle = LineStyleType.Thick;
//pivotStyle.Borders.LineStyle = LineStyleType.Thin;
//apply the style where you need to add
pivotTableStyle.Styles.Add(PivotTableElement.wholeTable, pivotStyle);
workbook.AddPivotTableStyle(pivotTableStyle);