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 Add Rows and Columns in Excel as a C# Developer

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

Regan Pun

July 15, 2023

In this tutorial, C# developers learn how to add rows and columns to Excel using IronXL with Visual Studio 2022. The process begins by downloading IronXL from the NuGet Package Manager, ensuring the latest version for optimal performance. Developers load the Excel file using the workbook.load method and then manipulate the default worksheet. To add a column before Column B, the insert column method is used, while the insert columns method allows adding multiple columns. Similarly, rows are added using the insert row and insert rows methods. Removing a row involves getting the row with the get row method and then applying the remove row method. The tutorial emphasizes zero-based indexing for accurate placement. After modifications, the workbook is saved with a new file name using the save as method to preserve the original file. The tutorial concludes by demonstrating the successful execution of the code, showcasing the modified Excel file. This guide provides a comprehensive approach to Excel manipulation using C# and IronXL, ensuring a smooth and efficient process for developers.

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 Auto Resize Rows and Columns in Excel

NEXT >
How to Add Freeze Panes to Spreadsheets in Excel