from ironxl import * # Supported for XLSX, XLS, XLSM, XLTX, CSV, and TSV workbook = WorkBook.Load("sample.xlsx") # Select worksheet at index 0 worksheet = workbook.WorkSheets[0] # Get any existing worksheet first_sheet = workbook.DefaultWorkSheet # Select a cell and return the converted value cell_value = worksheet["A2"].IntValue # Read from ranges of cells elegantly. for cell in worksheet["A2:A10"]: print("Cell {} has value '{}'".format(cell.AddressString, cell.Text)) # Calculate aggregate values such as Min, and Sum total_sum = worksheet["A2:A10"].Sum()

VIDEOS

How to Create an Excel File in C# using IronXL

Chaknith Bin

August 29, 2022

In this tutorial, we explore how to create Excel files in C# using the IronXL library, compatible with the .NET 6 framework. Begin by installing IronXL via the NuGet Package Manager. Import the library into your program and create a workbook using Workbook.Create. Customize your sheet by naming it and assigning values or formulas to specific cells. Format cells by adjusting border styles, background colors, and font styles. IronXL allows for formula integration, mimicking Excel's functionality, and provides sheet protection features to prevent unauthorized editing. Save your workbook locally through the Save As function. Run the project to generate an Excel file reflecting your code instructions. IronXL streamlines Excel operations without requiring Microsoft Excel or Excel Interop on your server. For further assistance, the support team is available to help.

Get stated with IronXL now.

Chaknith Bin

Chat with engineering team now

Software Engineer

Chaknith works on IronXL and IronBarcode. He has deep expertise in C# and .NET, helping improve the software and support customers. His insights from user interactions contribute to better products, documentation, and overall experience.