public object Subtotal(int GroupBy, XlConsolidationFunction Function, object TotalList, object Replace, object PageBreaks, XlSummaryRow SummaryBelowData) { throw new NotImplementedException(); }
/// <summary>创建指定区域或当前区域(如果该区域为单个单元格时)的分类汇总。 /// </summary> /// <param name="GroupBy">要作为分组依据的字段,为基于 1 的整数偏移量。有关详细信息,请参阅示例。</param> /// <param name="Function">分类汇总函数。</param> /// <param name="TotalList">基于 1 的字段偏移量数组,它指明将被分类汇总的字段。有关详细信息,请参阅示例。</param> /// <param name="Replace">如果为 True,则替换现有分类汇总。默认值为 True。</param> /// <param name="PageBreaks">如果为 True,则在每一组之后添加分页符。默认值为 False。</param> /// <param name="SummaryBelowData">放置相对于分类汇总的汇总数据。</param> public dynamic Subtotal(int GroupBy, XlConsolidationFunction Function, int TotalList, bool? Replace = null, bool? PageBreaks = null, XlSummaryRow SummaryBelowData = XlSummaryRow.xlSummaryBelow) { _objaParameters = new object[6] { GroupBy, Function, TotalList, Replace == null ? System.Type.Missing : Replace, PageBreaks == null ? System.Type.Missing : PageBreaks, SummaryBelowData }; return _objRange.GetType().InvokeMember("Subtotal", BindingFlags.InvokeMethod, null, _objRange, _objaParameters); }