格式化数据透视表单元格

Contents
[ ]

以下示例代码加载了包含两个数据透视表的 示例 Excel 文件,并实现了格式化整个数据透视表和格式化数据透视表中的单个单元格的操作。

// Create workbook object from source file containing pivot table
Workbook workbook = new Workbook("pivot_format.xlsx");
// Access the worksheet by its name
Worksheet worksheet = workbook.Worksheets["Sheet1"];
// Access the pivot table
PivotTable pivotTable = worksheet.PivotTables[1];
// Create a style object with background color light blue
Style style = workbook.CreateStyle();
style.Pattern = BackgroundType.Solid;
style.BackgroundColor = Color.LightBlue;
// Format entire pivot table with light blue color
pivotTable.FormatAll(style);
// Create another style object with yellow color
style = workbook.CreateStyle();
style.Pattern = BackgroundType.Solid;
style.BackgroundColor = Color.Yellow;
// Access the pivot table
PivotTable pivotTable2 = worksheet.PivotTables[0];
// Format the cell of pivot table
pivotTable2.Format(16, 5, style);
// Save the workbook object
workbook.Save("out.xlsx");

相关文章