精通 C# 中的 Excel 聚合函數
上面的代碼示例顯示了如何輕鬆地從Excel電子表格中的單元格範圍獲取匯總值。 但是，請注意，任何非數字的單元格將被留下。
總和
The method Sum()返回所選單元格範圍的總和。
平均
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()
