Пример #1
0
 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);
        }