聚合 Excel 函数
上面的代码示例展示了如何从 Excel 电子表格中的单元格区域轻松获取汇总值。但请注意，任何非数值单元格都将被忽略。
Sum
方法 `Sum()返回所选单元格区域的总和。
Average
方法 `Avg()返回所选单元格区域的平均值。
最低
方法 `Min()返回所选单元格区域中的最小数目。
最大
方法 `Max()返回所选单元格范围中的最大数字。
为提高灵活性，上述函数还可应用于单行/多行或多列。了解有关选择的更多信息 行和列.
using IronXL;
using System.Linq;
WorkBook workBook = WorkBook.Load("sample.xls");
WorkSheet workSheet = workBook.WorkSheets.First();
// Get range from worksheet
var range = workSheet["A1:A8"];
// Apply sum of all numeric cells within the range
decimal sum = range.Sum();
// Apply average value of all numeric cells within the range
decimal avg = range.Avg();
// Identify maximum value of all numeric cells within the range
decimal max = range.Max();
// Identify minimum value of all numeric cells within the range
decimal min = range.Min();Imports IronXL
Imports System.Linq
Private workBook As WorkBook = WorkBook.Load("sample.xls")
Private workSheet As WorkSheet = workBook.WorkSheets.First()
' Get range from worksheet
Private range = workSheet("A1:A8")
' Apply sum of all numeric cells within the range
Private sum As Decimal = range.Sum()
' Apply average value of all numeric cells within the range
Private avg As Decimal = range.Avg()
' Identify maximum value of all numeric cells within the range
Private max As Decimal = range.Max()
' Identify minimum value of all numeric cells within the range
Private min As Decimal = range.Min()
