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互通的煩惱。
