using IronXL; using System; using System.Linq; // Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV WorkBook workBook = WorkBook.Load("sample.xlsx"); // Select worksheet at index 0 WorkSheet workSheet = workBook.WorkSheets[0]; // Get any existing worksheet WorkSheet firstSheet = workBook.DefaultWorkSheet; // Select a cell and return the converted value int cellValue = workSheet["A2"].IntValue; // Read from ranges of cells elegantly. foreach (var cell in workSheet["A2:A10"]) { Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text); } // Calculate aggregate values such as Min, Max and Sum decimal sum = workSheet["A2:A10"].Sum(); // Linq compatible decimal max = workSheet["A2:A10"].Max(c => c.DecimalValue);

VIDEOS

How to Use Math Functions in Excel

Name: IronXL
Brand: Iron Software
Availability: InStock
Rating: 4.67 (175 reviews)

Regan Pun

March 31, 2024

This tutorial delves into utilizing the Ion XL library in C to enhance Excel's math functions. After ensuring the Ion XL library is installed via the NuGet package manager, users can import the library's namespace to easily access its methods. The tutorial guides users through loading a workbook and selecting the first worksheet to get a range of cells from A1 to A8. It demonstrates calculating the sum, average, maximum, and minimum values of these numeric cells using corresponding methods like Sum, AVG, Max, and Min. The calculated results are displayed on the console, showcasing their utility in data analysis. The tutorial encourages viewers to try these enhanced capabilities for themselves with a free trial, accessible through a provided link. By embracing these techniques, users can programmatically perform essential calculations, significantly boosting their Excel data analysis efficiency.

Get stated with IronXL now.

Regan Pun

Chat with engineering team now

Software Engineer

Regan graduated from the University of Reading, with a BA in Electronic Engineering. Before joining Iron Software, his previous job roles had him laser-focused on single tasks; and what he most enjoys at Iron Software is the spectrum of work he gets to undertake, whether it’s adding value to sales, technical support, product development or marketing. He enjoys understanding the way developers are using the Iron Software library, and using that knowledge to continually improve documentation and develop the products.

< PREVIOUS
How to Read and Create Excel Files in .NET MAUI Using C#

NEXT >
How to Load Existing Spreadsheets in C#