如何使用 IronXL.Excel 在 C# 中使用数学函数

Updated: 2026年6月4日

IronXL在直接在C#中对Excel数据进行Max等数学聚合函数。在任何单元格区域使用简单的单行方法计算总数和分析数值数据，而无需 Interop。无论是构建财务报告、分析销售数据还是处理科学测量，IronXL.Excel 的内置数学函数都能简化 .NET 应用程序中的 Excel 自动化工作流程。

Max@@--AH2EG--@@

立即使用IronXL计算从任何范围中提取maximum之类的聚合值。这些单行方法可以快速轻松地分析数值数据，而无需编写样板代码。该库可处理所有解析，并自动忽略非数字内容。

1Install IronXL with NuGet Package Manager
PM > Install-Package IronXL.Excel
```
Install-Package IronXL.Excel
```

2复制并运行这段代码。

decimal total = workSheet["A1:A8"].Sum();
decimal maximum = workSheet["A1:A8"].Max();

decimal total = workSheet["A1:A8"].Sum();
decimal maximum = workSheet["A1:A8"].Max();

3部署到您的生产环境中进行测试

通过免费试用立即在您的项目中开始使用IronXL

最小工作流程（5 个步骤）

下载用于使用聚合函数的 C# 库
加载现有 Excel 文件
选择要聚合的所需范围、行或列
调用可用的数学函数，例如Sum 、 Avg 、 Min或Max
根据结果进行进一步计算

如何在 Excel 中使用 C# 的聚合函数？

在 Excel 电子表格中处理单元格范围时，可以利用各种聚合函数进行计算。 IronXL 提供了与 Excel 内置函数相匹配的数学运算，使您可以轻松地在 C# 中操作 Excel 数据，而无需安装 Microsoft Office。以下是基本方法：

Sum()方法计算选定单元格的总和。
Avg()方法确定选定单元格的平均值。
Min()方法识别选定单元格中的最小数字。
Max()方法找出选定单元格内的最大数字。

这些函数是分析数据和从 Excel 电子表格中获得有意义见解的宝贵工具。这些工具可以自动处理各种数字格式，包括整数、小数、货币值和百分比。在处理大型数据集时，与手动单元格迭代相比，这些方法具有卓越的性能。

请注意: 非数字值将不包括在计算中。

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"];

// Calculate the sum of numeric cells within the range
decimal sum = range.Sum();

// Calculate the average value of numeric cells within the range
decimal avg = range.Avg();

// Identify the maximum value among numeric cells within the range
decimal max = range.Max();

// Identify the minimum value among numeric cells within the range
decimal min = range.Min();

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"];

// Calculate the sum of numeric cells within the range
decimal sum = range.Sum();

// Calculate the average value of numeric cells within the range
decimal avg = range.Avg();

// Identify the maximum value among numeric cells within the range
decimal max = range.Max();

// Identify the minimum value among 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")

' Calculate the sum of numeric cells within the range
Dim sum As Decimal = range.Sum()

' Calculate the average value of numeric cells within the range
Dim avg As Decimal = range.Avg()

' Identify the maximum value among numeric cells within the range
Dim max As Decimal = range.Max()

' Identify the minimum value among 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")

' Calculate the sum of numeric cells within the range
Dim sum As Decimal = range.Sum()

' Calculate the average value of numeric cells within the range
Dim avg As Decimal = range.Avg()

' Identify the maximum value among numeric cells within the range
Dim max As Decimal = range.Max()

' Identify the minimum value among numeric cells within the range
Dim min As Decimal = range.Min()

哪些数学函数可用？

除核心聚合功能外，IronXL 还支持一整套数学运算，可与 C# Excel 工作流无缝集成。每个功能都经过优化，以保证性能和准确性：

Sum()方法计算选定单元格的总和，非常适合财务总额、库存数或累积计算。它可以高效处理数千个单元格，同时保持十进制精度。

Avg()方法确定选定单元格的平均值，理想用于计算平均分数、平均销售额或统计分析。该功能可自动排除空单元格和非数值。

Min()方法识别选定单元格中的最小数字，有助于找到最低价格、最低阈值或数据分析中的基线值。

Max()方法找出选定单元格中的最大数字，对于确定数据集中的峰值、最高分或上限值至关重要。

这些数学函数可与 IronXL.Excel 的其他功能（如单元格格式化和公式支持）无缝配合，从而实现全面的 Excel 自动化场景。

如何在C#中计算总和（合计）？

Sum()方法计算选定范围内所有数值的总和，执行单元格间的数学求和操作（Σ）。这使其成为财务总计、库存计数和大数据集累计计算的理想选择。

使用括号表示法["B2:B50"]在一行中定位特定范围并计算总和：

using IronXL;

WorkBook workBook = WorkBook.Load("sales-data.xlsx");
WorkSheet sheet = workBook.DefaultWorkSheet;

// Calculate total sales from range
decimal totalSales = sheet["B2:B50"].Sum();
Console.WriteLine($"Total Sales: ${totalSales:N2}");

using IronXL;

WorkBook workBook = WorkBook.Load("sales-data.xlsx");
WorkSheet sheet = workBook.DefaultWorkSheet;

// Calculate total sales from range
decimal totalSales = sheet["B2:B50"].Sum();
Console.WriteLine($"Total Sales: ${totalSales:N2}");

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("sales-data.xlsx")
Dim sheet As WorkSheet = workBook.DefaultWorkSheet

' Calculate total sales from range
Dim totalSales As Decimal = sheet("B2:B50").Sum()
Console.WriteLine($"Total Sales: {totalSales:N2}")

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("sales-data.xlsx")
Dim sheet As WorkSheet = workBook.DefaultWorkSheet

' Calculate total sales from range
Dim totalSales As Decimal = sheet("B2:B50").Sum()
Console.WriteLine($"Total Sales: {totalSales:N2}")

请注意: 空单元格和非数字值会自动从计算中排除。

如何在C#中计算平均值？

Avg()方法计算选定单元格的算术平均值，非常适合计算平均分数、平均销售额或跨数据集的统计分析。

该方法以完整精度返回decimal值，以确保准确的统计计算：

using IronXL;

WorkBook workBook = WorkBook.Load("student-grades.xlsx");
WorkSheet sheet = workBook.DefaultWorkSheet;

// Calculate average grade for a student
decimal avgGrade = sheet["C2:C10"].Avg();
Console.WriteLine($"Average Grade: {avgGrade:F2}");

using IronXL;

WorkBook workBook = WorkBook.Load("student-grades.xlsx");
WorkSheet sheet = workBook.DefaultWorkSheet;

// Calculate average grade for a student
decimal avgGrade = sheet["C2:C10"].Avg();
Console.WriteLine($"Average Grade: {avgGrade:F2}");

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("student-grades.xlsx")
Dim sheet As WorkSheet = workBook.DefaultWorkSheet

' Calculate average grade for a student
Dim avgGrade As Decimal = sheet("C2:C10").Avg()
Console.WriteLine($"Average Grade: {avgGrade:F2}")

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("student-grades.xlsx")
Dim sheet As WorkSheet = workBook.DefaultWorkSheet

' Calculate average grade for a student
Dim avgGrade As Decimal = sheet("C2:C10").Avg()
Console.WriteLine($"Average Grade: {avgGrade:F2}")

请注意: 平均值仅从包含数值的单元中计算，自动跳过空单元或文本单元。

如何在C#中找到最小值？

Min()方法识别范围内的最小数值。除了商业应用，如查找最低价格或最低阈值外，此功能在数学背景下同样有价值，例如确定下限、识别坐标数据中的顶点，或建立统计分析的基线值。

直接在任何范围上应用Min()，可瞬间扫描数百个值：

using IronXL;

WorkBook workBook = WorkBook.Load("product-prices.xlsx");
WorkSheet sheet = workBook.DefaultWorkSheet;

// Find the lowest price
decimal lowestPrice = sheet["D2:D100"].Min();
Console.WriteLine($"Lowest Price: ${lowestPrice:N2}");

using IronXL;

WorkBook workBook = WorkBook.Load("product-prices.xlsx");
WorkSheet sheet = workBook.DefaultWorkSheet;

// Find the lowest price
decimal lowestPrice = sheet["D2:D100"].Min();
Console.WriteLine($"Lowest Price: ${lowestPrice:N2}");

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("product-prices.xlsx")
Dim sheet As WorkSheet = workBook.DefaultWorkSheet

' Find the lowest price
Dim lowestPrice As Decimal = sheet("D2:D100").Min()
Console.WriteLine($"Lowest Price: ${lowestPrice:N2}")

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("product-prices.xlsx")
Dim sheet As WorkSheet = workBook.DefaultWorkSheet

' Find the lowest price
Dim lowestPrice As Decimal = sheet("D2:D100").Min()
Console.WriteLine($"Lowest Price: ${lowestPrice:N2}")

如何在C#中找到最大值？

Max()方法定位范围内的最大数值。无论是识别业务分析中的峰值，找到几何计算中的最大顶点，还是确定数学模型中的上限，此功能简化了数据极值分析。

处理大型数据集，如整整一年的每日读数（Max()调用：

using IronXL;

WorkBook workBook = WorkBook.Load("temperature-data.xlsx");
WorkSheet sheet = workBook.DefaultWorkSheet;

// Find the highest temperature recorded
decimal maxTemp = sheet["E2:E365"].Max();
Console.WriteLine($"Highest Temperature: {maxTemp:F1}°F");

using IronXL;

WorkBook workBook = WorkBook.Load("temperature-data.xlsx");
WorkSheet sheet = workBook.DefaultWorkSheet;

// Find the highest temperature recorded
decimal maxTemp = sheet["E2:E365"].Max();
Console.WriteLine($"Highest Temperature: {maxTemp:F1}°F");

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("temperature-data.xlsx")
Dim sheet As WorkSheet = workBook.DefaultWorkSheet

' Find the highest temperature recorded
Dim maxTemp As Decimal = sheet("E2:E365").Max()
Console.WriteLine($"Highest Temperature: {maxTemp:F1}°F")

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("temperature-data.xlsx")
Dim sheet As WorkSheet = workBook.DefaultWorkSheet

' Find the highest temperature recorded
Dim maxTemp As Decimal = sheet("E2:E365").Max()
Console.WriteLine($"Highest Temperature: {maxTemp:F1}°F")

我可以聚合哪些数据类型？

这些功能是分析数据和从 Excel 电子表格中获取见解的重要工具。 IronXL.Excel 的数学函数支持 Excel 文件中常见的各种数字数据类型：

**整数和小数：**标准数值以完全精度处理
**货币值：**带有货币符号的金额正确解析
**百分比：**计算中适当地处理百分比值
**科学计数法：**支持以科学格式表示的大数或小数
**日期序列号：**需要时聚合Excel的内部日期表示

在处理混合数据类型时，IronXL 可智能处理转换，确保结果准确无误。对于涉及多个工作表或工作簿的复杂场景，您可以轻松地同时加载和处理多个 Excel 文件。

下面是一个演示不同数字格式聚合的示例：

using IronXL;

// Load workbook containing various numeric formats
WorkBook workBook = WorkBook.Load("financial-data.xlsx");
WorkSheet salesSheet = workBook.GetWorkSheet("Q4Sales");

// Calculate total revenue from currency-formatted cells
decimal totalRevenue = salesSheet["B2:B50"].Sum();
Console.WriteLine($"Total Q4 Revenue: ${totalRevenue:N2}");

// Find the highest individual sale amount
decimal maxSale = salesSheet["B2:B50"].Max();
Console.WriteLine($"Largest Sale: ${maxSale:N2}");

// Calculate average sale amount
decimal avgSale = salesSheet["B2:B50"].Avg();
Console.WriteLine($"Average Sale: ${avgSale:N2}");

// Process percentage data (e.g., tax rates)
decimal avgTaxRate = salesSheet["D2:D50"].Avg();
Console.WriteLine($"Average Tax Rate: {avgTaxRate:P2}");

using IronXL;

// Load workbook containing various numeric formats
WorkBook workBook = WorkBook.Load("financial-data.xlsx");
WorkSheet salesSheet = workBook.GetWorkSheet("Q4Sales");

// Calculate total revenue from currency-formatted cells
decimal totalRevenue = salesSheet["B2:B50"].Sum();
Console.WriteLine($"Total Q4 Revenue: ${totalRevenue:N2}");

// Find the highest individual sale amount
decimal maxSale = salesSheet["B2:B50"].Max();
Console.WriteLine($"Largest Sale: ${maxSale:N2}");

// Calculate average sale amount
decimal avgSale = salesSheet["B2:B50"].Avg();
Console.WriteLine($"Average Sale: ${avgSale:N2}");

// Process percentage data (e.g., tax rates)
decimal avgTaxRate = salesSheet["D2:D50"].Avg();
Console.WriteLine($"Average Tax Rate: {avgTaxRate:P2}");

Imports IronXL

' Load workbook containing various numeric formats
Dim workBook As WorkBook = WorkBook.Load("financial-data.xlsx")
Dim salesSheet As WorkSheet = workBook.GetWorkSheet("Q4Sales")

' Calculate total revenue from currency-formatted cells
Dim totalRevenue As Decimal = salesSheet("B2:B50").Sum()
Console.WriteLine($"Total Q4 Revenue: {totalRevenue:N2}")

' Find the highest individual sale amount
Dim maxSale As Decimal = salesSheet("B2:B50").Max()
Console.WriteLine($"Largest Sale: {maxSale:N2}")

' Calculate average sale amount
Dim avgSale As Decimal = salesSheet("B2:B50").Avg()
Console.WriteLine($"Average Sale: {avgSale:N2}")

' Process percentage data (e.g., tax rates)
Dim avgTaxRate As Decimal = salesSheet("D2:D50").Avg()
Console.WriteLine($"Average Tax Rate: {avgTaxRate:P2}")

Imports IronXL

' Load workbook containing various numeric formats
Dim workBook As WorkBook = WorkBook.Load("financial-data.xlsx")
Dim salesSheet As WorkSheet = workBook.GetWorkSheet("Q4Sales")

' Calculate total revenue from currency-formatted cells
Dim totalRevenue As Decimal = salesSheet("B2:B50").Sum()
Console.WriteLine($"Total Q4 Revenue: {totalRevenue:N2}")

' Find the highest individual sale amount
Dim maxSale As Decimal = salesSheet("B2:B50").Max()
Console.WriteLine($"Largest Sale: {maxSale:N2}")

' Calculate average sale amount
Dim avgSale As Decimal = salesSheet("B2:B50").Avg()
Console.WriteLine($"Average Sale: {avgSale:N2}")

' Process percentage data (e.g., tax rates)
Dim avgTaxRate As Decimal = salesSheet("D2:D50").Avg()
Console.WriteLine($"Average Tax Rate: {avgTaxRate:P2}")

我可以对行和列应用函数吗？

为提高灵活性，这些功能还可应用于单行或多行和多列。了解有关选择范围（包括整行和整列）的更多信息。在处理需要进行特定维度计算的结构化数据时，这种能力尤其有用。

您可以将数学函数应用于

**整个列：**计算整个数据列的总和
**整个行：**汇总基于行的记录中的值
**多个范围：**结合多个选择以进行复杂计算
**命名范围：**使用命名范围以维护代码

下面是一个显示行和列聚合的实用示例：

using IronXL;

WorkBook workBook = WorkBook.Load("quarterly-report.xlsx");
WorkSheet dataSheet = workBook.DefaultWorkSheet;

// Calculate sum for entire column (e.g., all sales data)
decimal columnTotal = dataSheet.GetColumn(1).Sum(); // Column B

// Calculate average for entire row (e.g., monthly averages)
decimal rowAverage = dataSheet.GetRow(4).Avg(); // Row 5

// Work with multiple columns simultaneously
for (int col = 1; col <= 12; col++) // Columns B through M
{
    decimal monthlyTotal = dataSheet.GetColumn(col).Sum();
    Console.WriteLine($"Month {col} Total: ${monthlyTotal:N2}");
}

// Calculate grand total across multiple ranges
var q1Range = dataSheet["B2:D50"];
var q2Range = dataSheet["E2:G50"];
decimal firstHalfTotal = q1Range.Sum() + q2Range.Sum();

using IronXL;

WorkBook workBook = WorkBook.Load("quarterly-report.xlsx");
WorkSheet dataSheet = workBook.DefaultWorkSheet;

// Calculate sum for entire column (e.g., all sales data)
decimal columnTotal = dataSheet.GetColumn(1).Sum(); // Column B

// Calculate average for entire row (e.g., monthly averages)
decimal rowAverage = dataSheet.GetRow(4).Avg(); // Row 5

// Work with multiple columns simultaneously
for (int col = 1; col <= 12; col++) // Columns B through M
{
    decimal monthlyTotal = dataSheet.GetColumn(col).Sum();
    Console.WriteLine($"Month {col} Total: ${monthlyTotal:N2}");
}

// Calculate grand total across multiple ranges
var q1Range = dataSheet["B2:D50"];
var q2Range = dataSheet["E2:G50"];
decimal firstHalfTotal = q1Range.Sum() + q2Range.Sum();

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("quarterly-report.xlsx")
Dim dataSheet As WorkSheet = workBook.DefaultWorkSheet

' Calculate sum for entire column (e.g., all sales data)
Dim columnTotal As Decimal = dataSheet.GetColumn(1).Sum() ' Column B

' Calculate average for entire row (e.g., monthly averages)
Dim rowAverage As Decimal = dataSheet.GetRow(4).Avg() ' Row 5

' Work with multiple columns simultaneously
For col As Integer = 1 To 12 ' Columns B through M
    Dim monthlyTotal As Decimal = dataSheet.GetColumn(col).Sum()
    Console.WriteLine($"Month {col} Total: ${monthlyTotal:N2}")
Next

' Calculate grand total across multiple ranges
Dim q1Range = dataSheet("B2:D50")
Dim q2Range = dataSheet("E2:G50")
Dim firstHalfTotal As Decimal = q1Range.Sum() + q2Range.Sum()

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("quarterly-report.xlsx")
Dim dataSheet As WorkSheet = workBook.DefaultWorkSheet

' Calculate sum for entire column (e.g., all sales data)
Dim columnTotal As Decimal = dataSheet.GetColumn(1).Sum() ' Column B

' Calculate average for entire row (e.g., monthly averages)
Dim rowAverage As Decimal = dataSheet.GetRow(4).Avg() ' Row 5

' Work with multiple columns simultaneously
For col As Integer = 1 To 12 ' Columns B through M
    Dim monthlyTotal As Decimal = dataSheet.GetColumn(col).Sum()
    Console.WriteLine($"Month {col} Total: ${monthlyTotal:N2}")
Next

' Calculate grand total across multiple ranges
Dim q1Range = dataSheet("B2:D50")
Dim q2Range = dataSheet("E2:G50")
Dim firstHalfTotal As Decimal = q1Range.Sum() + q2Range.Sum()

对于高级 Excel 操作场景，请将这些数学函数与其他 IronXL 功能相结合，如创建图表、应用条件格式化或导出为不同格式。这使得 IronXL.Excel 成为.NET 应用程序中 Excel 自动化的全面解决方案，无论是构建报表工具、数据分析系统还是商业智能仪表板。

常见问题解答

如何使用 C# 计算 Excel 中单元格的总和？

using IronXL，您可以使用一个简单的单行方法计算任意单元格区域的总和：decimal total = workSheet["A1:A8"].Sum()。该方法可自动处理所有数字格式，包括整数、小数、货币值和百分比，同时忽略非数字内容。

C# 中有哪些数学函数可用于 Excel 数据分析？

IronXL 提供了基本的数学运算功能，包括求总数的 Sum()、求平均数的 Avg()、求最小值的 Min() 和求最大值的 Max()。这些函数反映了 Excel 的内置功能，无需安装 Microsoft Office 即可在任何单元格范围内无缝运行。

没有安装 Microsoft Office，我可以进行 Excel 计算吗？

是的，IronXL 可让您直接在 C# 中执行所有 Excel 数学函数，而无需 Microsoft Office 或 Interop。该库可独立处理 Excel 文件操作，因此非常适合服务器环境和自动化工作流程。

IronXL 如何处理计算中的非数值？

IronXL 会自动排除所有数学计算中的非数值。在使用 Sum()、Avg()、Min() 或 Max() 等函数时，该库会智能解析单元格内容，只包含有效的数值数据，从而确保无需手动清理数据即可获得准确结果。

用 C# 在 Excel 中分析数值数据的最快方法是什么？

IronXL 的内置聚合函数可为大型数据集提供卓越的性能。只需选择范围并调用 workSheet["A1:A100"].Sum() 或 workSheet["B1:B100"].Max() 等方法即可。这些优化方法比手动单元格迭代要快得多。

我可以在特定行或列上使用这些数学函数吗？

是的，IronXL.Excel 的数学函数适用于任何有效的 Excel 范围选择，包括整行、整列或自定义范围。通过在选择语法中定义适当的范围，您可以汇总电子表格中特定区域的数据。

What are the benefits of using IronXL for Excel automation?

IronXL streamlines Excel automation by providing simple, effective functions for data analysis, efficient handling of large datasets, and compatibility with various numeric formats, all without requiring Microsoft Excel to be installed.

Can IronXL work with entire columns or rows for aggregation?

Yes, IronXL allows aggregation of entire columns or rows using its math functions. You can calculate totals or averages for complete columns or rows, making it easy to work with structured datasets.

How do I perform calculations across multiple Excel ranges in IronXL?

IronXL allows combining multiple ranges for comprehensive calculations. By summing results from different ranges, such as `firstHalfTotal = q1Range.Sum() + q2Range.Sum();`, you can aggregate data across diverse selections.

What additional features does IronXL offer for Excel manipulation?

Apart from math functions, IronXL features capabilities like creating charts, applying conditional formatting, and exporting to various file formats, making it a versatile tool for comprehensive Excel automation.