使用C#生成Excel PivotTables怎么设置格式

Question

如题所述

Answer 1

//得到Excel
Spire.Xls.Workbook workbook = new Spire.Xls.Workbook();
workbook.LoadFromFile(@"C:\CommodityBlueInfo\Contrast SRVInfo_0617.xlsx");
Spire.Xls.Worksheet sheet = workbook.Worksheets[0];
sheet.Name = "Contrast-1";
Spire.Xls.Worksheet sheet2 = workbook.CreateEmptySheet();
sheet2.Name = "Pivot Table";
//得到Excel中的数据
CellRange dataRange = sheet.Range["A1:F6"];
PivotCache cache = workbook.PivotCaches.Add(dataRange);
PivotTable pt = sheet2.PivotTables.Add("Pivot Table", sheet.Range["A1"], cache);

var r1 = pt.PivotFields["Subsystem"];
r1.Axis = AxisTypes.Row;
pt.Options.RowHeaderCaption = "Subsystem";

var r2 = pt.PivotFields["HW Desc"];
r2.Axis = AxisTypes.Row;
//r2.Formula = "";
pt.BuiltInStyle = PivotBuiltInStyles.PivotStyleMedium12;

workbook.SaveToFile(@"Contrast SRVInfo_0121.xlsx", ExcelVersion.Version2010);
System.Diagnostics.Process.Start(@"Contrast SRVInfo_0121.xlsx");本回答被提问者采纳