在Excel Pivotable C#中创建计算字段 [英] Create Calculated Field in Excel Pivotable C#

问题描述

任何人都可以帮助我将此excel宏转换为c#.我需要添加
将计算出的字段以编程方式添加到我的数据透视表中.

Can anyone help me convert this excel macro to c#. I need to add
the calculated field to my pivot table programmaticlly.

ActiveSheet.PivotTables("MFRData").CalculatedFields.Add "calc", _
       "=order_qty *  +order_qty * 10%", True
   ActiveSheet.PivotTables("MFRData").PivotFields("calc").Orientation = _
       xlDataField

推荐答案

Excel.PivotTable pt = xlSheet.PivotTables("MFRData");
Excel.PivotField ptField
Excel.CalculatedFields cfField = pt.CalculatedFields();
ptField = cfField .Add("calc", "='order_qty' * +'order_qty' * 10%", true);
pt.AddDataField(ptField , " calc", Excel.XlConsolidationFunction.xlSum);

这篇关于在Excel Pivotable C#中创建计算字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！