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 Export Excel Data Using C#

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

Regan Pun

November 1, 2022

In this tutorial, viewers learn how to export Excel spreadsheet data into various formats using C# and IronXL. The process begins with setting up a console application in Visual Studio 2022, followed by installing IronXL via the NuGet Package Manager. After importing the IronXL library in code, the Excel file is loaded using the Workbook Load function. The tutorial guides users through exporting the Excel file to different formats, including CSV, JSON, and XML, using the Save As methods. For each file type, the path for the saved file is specified, and the generated files are reviewed to ensure data integrity and formatting consistency. The tutorial highlights IronXL’s effectiveness in maintaining original data formatting across exported files, making it a reliable tool for developers needing versatile data conversion capabilities. The tutorial concludes by offering support for further assistance, emphasizing IronXL's utility and user-friendliness in Excel data manipulation.

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 Convert Spreadsheet Files to JSON, CSV, XML & More with IronXL in C#

NEXT >
How to Use Excel Interop in C# Alternatively