You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

如何将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

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.08.17 09:30:46