如何将EPPlus生成的数据透视表从紧凑格式改为表格格式?
问题:数据透视表中「Reviewer」与「Engagement」字段无法分开显示
我尝试设置Compact = false、CompactData = false等参数,但均未生效,希望将「Reviewer」和「Engagement」字段分开显示,而非合并在同一字段中。以下是我使用的代码:
//define the data range on the source sheet var dataRange = workSheetDataSource.Cells[workSheetDataSource.Dimension.Address]; //create the pivot table var pivotTable = workSheetMgrAndEng.PivotTables.Add(workSheetMgrAndEng.Cells["A4"], dataRange, "PivotTable"); //label field pivotTable.RowFields.Add(pivotTable.Fields["Reviewer"]); pivotTable.RowFields.Add(pivotTable.Fields["Engagement"]); //pivot field settings pivotTable.Compact = false; pivotTable.CompactData = false; pivotTable.Indent = 0; //pivotTable.RowGrandTotals = false; pivotTable.UseAutoFormatting = true; //pivotTable.ShowMemberPropertyTips = false; pivotTable.DataOnRows = false; //data fields var field1 = pivotTable.DataFields.Add(pivotTable.Fields["Engagement"]); field1.Name = "Count of Engagement"; field1.Function = DataFieldFunctions.Count; var field2 = pivotTable.DataFields.Add(pivotTable.Fields["Prep Complete"]); field2.Name = "Count of Prep Complete"; field2.Function = DataFieldFunctions.Count; var field3 = pivotTable.DataFields.Add(pivotTable.Fields["Sent Delivered"]); field3.Name = "Sent/Delivered"; field3.Function = DataFieldFunctions.Count; var field4 = pivotTable.DataFields.Add(pivotTable.Fields["Return to Tax Office"]); field4.Name = "Count of Return to Tax Office"; field4.Function = DataFieldFunctions.Count; //data fields settings //field1.Field.Outline = false; field1.Field.Compact = false; field1.Field.ShowAll = false; //field1.Field.SubtotalTop = false; //field2.Field.Outline = false; field2.Field.Compact = false; field2.Field.ShowAll = false; //field2.Field.SubtotalTop = false; //field3.Field.Outline = false; field3.Field.Compact = false; field3.Field.ShowAll = false; //field3.Field.SubtotalTop = false; //field4.Field.Outline = false; field4.Field.Compact = false; field4.Field.ShowAll = false; //field4.Field.SubtotalTop = false;
我附上了两张图片,第一张是当前生成的输出效果,第二张是我期望实现的效果:


内容的提问来源于stack exchange,提问作者chir
相关产品推荐
相关产品推荐

