可以是 XlConsolidationFunction 的常量之一。 只读 Long。语法表达式。ConsolidationFunction表达 一个代表 Worksheet 对象的变量。示例如果当前合并计算所使用的函数为 SUM 函数,本示例将显示一消息框。VB 复制 If Worksheets("Sheet1").ConsolidationFunction = xlSum Then MsgBox "Sheet1 uses the SUM function for...
名前空間: Microsoft.Office.Interop.Excel アセンブリ: Microsoft.Office.Interop.Excel.dll 集計に使用する関数を指定します。C# コピー public enum XlConsolidationFunction継承 Enum XlConsolidationFunction フィールドテーブルを展開する 名前値説明 xlVarP -4165 母集団全体に基づく変動 xlVar -...
Microsoft.Office.Tools.Excel Assemblies: Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll Gets the function code used for the current consolidation. C# publicMicrosoft.Office.Interop.Excel.XlConsolidationFunction ConsolidationFunction {get; } ...
Namespace: Microsoft.Office.Interop.Excel Assembly: Microsoft.Office.Interop.Excel.dll Specifies the subtotal function.C# Copy public enum XlConsolidationFunctionInheritance Enum XlConsolidationFunction FieldsExpand table NameValueDescription xlVarP -4165 Variation, based on the whole population. xlVar ...
Excel Assembly: Microsoft.Office.Interop.Excel.dll Returns the function code used for the current consolidation. Can be one of the XlConsolidationFunction constants. Read-only. C# 複製 public Microsoft.Office.Interop.Excel.XlConsolidationFunction ConsolidationFunction { get; } Property Value Xl...
Specifies the subtotal function.Expand table NameValueDescription xlAverage -4106 Average. xlCount -4112 Count. xlCountNums -4113 Count numerical values only. xlDistinctCount 11 Count using Distinct Count analysis. xlMax -4136 Maximum. xlMin -4139 Minimum. xlProduct -4149 Multiply. xlStDev -...
simpleName ="Sum()";break;caseExcel.XlConsolidationFunction.xlMax: simpleName ="Max()";break;caseExcel.XlConsolidationFunction.xlProduct: simpleName ="Product()";break;default: simpleName ="Other";break; } MessageBox.Show("This worksheet uses "+ simpleName +" for the consolidation function."...
程序集: Microsoft.Office.Tools.Excel(在 Microsoft.Office.Tools.Excel.dll 中) Microsoft.Office.Tools.Excel.v4.0.Utilities(在 Microsoft.Office.Tools.Excel.v4.0.Utilities.dll 中) 语法 C# 复制 XlConsolidationFunction ConsolidationFunction { get; } 属性值 类型:Microsoft.Office.Interop.E...
Click on Consolidate in the Data Tools group. Choose the Consolidation Function: In the Consolidate dialog box, select the function you want to use (e.g., Sum, Average, Count). Add the Data Ranges: Click on Add to include each data range you want to consolidate. You can select ranges ...
a脏腑功能失调 Internal organs function detuning[translate] a孩子们不知道怎样把那个风筝从树上摘下来 The children did not know how picks down that kite from the tree[translate] a把…加起来 …Adds[translate] ayou like clena.the rabbit is clean and loveiy .you will be happy with it. 您喜欢cle...