VIDEOS

How to Write to Excel Files in .NET with C#

Regan Pun
Regan Pun
February 24, 2025
Share:


In this tutorial, we delve into the process of writing and modifying Excel files using C# with the help of the IronXL library. The session starts by installing IronXL via the NuGet package manager and opening the program.cs file. We begin by loading an Excel workbook, 'sample.xlsx', and creating a worksheet object. The tutorial demonstrates how to write new values to cell A1, save the workbook as 'sample1.xlsx', and write values to specified ranges such as B2 to B9 and C3 to B7, saving the result as 'sample2.xlsx'. It further explores dynamic value insertion using a for loop across a specified range of rows, saving the file as 'sample3.xlsx'. Text replacement is also covered, showcasing how to replace text throughout the worksheet and in specific areas, resulting in 'sample4.xlsx'. The tutorial concludes with a demonstration of the output files, encouraging users to visit the IronXL website for advanced features and to explore IronPDF for more functionality. Viewers are invited to subscribe for more tutorials and to download the software to experience its capabilities.

Get stated with IronXL now.
green arrow pointer

Regan Pun
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 Create an Excel File in C# using IronXL
NEXT >
How to Create and Read Excel Files in VB .NET