Test in production without watermarks.
Works wherever you need it to.
Get 30 days of fully functional product.
Have it up and running in minutes.
Full access to our support engineering team during your product trial
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.
Further Reading: Write Excel .NET Functions