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 Manage Excel Worksheets in C#

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

Regan Pun

May 26, 2024

In this video tutorial, you will learn how to manage Excel worksheets using the IronXL library in C#. The tutorial begins by guiding viewers to set up a Visual Studio C# project with IronXL installed. Key tasks demonstrated include creating a new Excel workbook and populating it with four worksheets using the 'create worksheet' method. IronXL's versatility is showcased by shuffling worksheet order, setting an active tab with 'set sheet position,' and removing worksheets. Additionally, viewers learn to clone and rename sheets, saving changes with a different file name for comparison. The tutorial emphasizes the ease of managing Excel files with IronXL, encouraging users to explore further. The video concludes with a call to subscribe for more tips and tricks, and a link is provided to try IronXL software.

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.

NEXT >
How to Read Excel Files in C# using IronXL