使用C#生成Excel PivotTables怎么设置格式?在线等大神

//得到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");

补充：.NET技术 ,  图表区

上一个：C# 读取App.Config 文件
下一个：求教开发思路的选择