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
Dim workBook As WorkBook = WorkBook.Load("sample.xls")
Dim workSheet As WorkSheet = workBook.WorkSheets.First()
' Get range from worksheet
Dim range = workSheet("A1:A8")
' Apply sum of all numeric cells within the range
Dim sum As Decimal = range.Sum()
' Apply average value of all numeric cells within the range
Dim avg As Decimal = range.Avg()
' Identify maximum value of all numeric cells within the range
Dim max As Decimal = range.Max()
' Identify minimum value of all numeric cells within the range
Dim min As Decimal = range.Min()Imports IronXL
Imports System.Linq
Dim workBook As WorkBook = WorkBook.Load("sample.xls")
Dim workSheet As WorkSheet = workBook.WorkSheets.First()
' Get range from worksheet
Dim range = workSheet("A1:A8")
' Apply sum of all numeric cells within the range
Dim sum As Decimal = range.Sum()
' Apply average value of all numeric cells within the range
Dim avg As Decimal = range.Avg()
' Identify maximum value of all numeric cells within the range
Dim max As Decimal = range.Max()
' Identify minimum value of all numeric cells within the range
Dim min As Decimal = range.Min()
上面的代码示例展示了如何轻松地从 Excel 电子表格中的一系列单元格中获取聚合值。 但是请注意，任何非数字单元格都将被忽略。
Sum方法Sum()返回选定单元格范围的总和。
Average方法Average()返回选定单元格范围的平均值。
Minimum方法Min()返回选定单元格范围中的最小数。
Maximum方法Max()返回选定单元格范围中的最大数。
为了更灵活地处理数据，上述函数也可以应用于单行/多行或多列。 了解更多关于选择行和列的信息。
使用 C# 探索 Excel 中的数学函数Nuget Downloads 2,362,812|版本:2026.11刚刚发布
IronXL 是 IRONSUITE的一部分
10 个 .NET API 产品用于您的办公文档
您需要的 Excel API，无需 Office Interop 烦恼。
