How to Use Math Functions

using IronXL;
using System.Linq;

// Load an Excel workbook
// The Load method opens an Excel file with the specified path.
WorkBook workBook = WorkBook.Load("sample.xls");

// Access the first worksheet in the workbook
// The First method retrieves the first WorkSheet from the WorkSheets collection.
WorkSheet workSheet = workBook.WorkSheets.First();

// Get a range of cells from the worksheet (cells A1 to A8)
// This specifies a range in the Excel sheet using the indexer method.
var range = workSheet["A1:A8"];

// Calculate the sum of all numeric cells within the specified range
// The Sum extension method iterates over all cells in the range and calculates the sum of numeric values.
double sum = range.Sum(cell => cell.DoubleValue);

// Calculate the average value of all numeric cells within the specified range
// The Average extension method calculates the mean of all numeric values.
double avg = range.Average(cell => cell.DoubleValue);

// Identify the maximum value among all numeric cells within the specified range
// The Max extension method returns the largest value among the numeric cells.
double max = range.Max(cell => cell.DoubleValue);

// Identify the minimum value among all numeric cells within the specified range
// The Min extension method returns the smallest value among the numeric cells.
double min = range.Min(cell => cell.DoubleValue);

Imports IronXL

Imports System.Linq



' Load an Excel workbook

' The Load method opens an Excel file with the specified path.

Private workBook As WorkBook = WorkBook.Load("sample.xls")



' Access the first worksheet in the workbook

' The First method retrieves the first WorkSheet from the WorkSheets collection.

Private workSheet As WorkSheet = workBook.WorkSheets.First()



' Get a range of cells from the worksheet (cells A1 to A8)

' This specifies a range in the Excel sheet using the indexer method.

Private range = workSheet("A1:A8")



' Calculate the sum of all numeric cells within the specified range

' The Sum extension method iterates over all cells in the range and calculates the sum of numeric values.

Private sum As Double = range.Sum(Function(cell) cell.DoubleValue)



' Calculate the average value of all numeric cells within the specified range

' The Average extension method calculates the mean of all numeric values.

Private avg As Double = range.Average(Function(cell) cell.DoubleValue)



' Identify the maximum value among all numeric cells within the specified range

' The Max extension method returns the largest value among the numeric cells.

Private max As Double = range.Max(Function(cell) cell.DoubleValue)



' Identify the minimum value among all numeric cells within the specified range

' The Min extension method returns the smallest value among the numeric cells.

Private min As Double = range.Min(Function(cell) cell.DoubleValue)