總計 Excel 函數
上面的代碼範例顯示如何輕鬆地從 Excel 試算表中的單元格範圍獲取聚合值。但是，請注意，任何非數字單元格都會被忽略。
總結
方法 `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()
