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

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

Regan Pun

May 26, 2024

In this tutorial, we delve into Excel manipulation using IronXL in C#. The session begins with setting up a C# project in Visual Studio and integrating IronXL via the NuGet package manager. By importing IronXL, users can leverage its capabilities to load Excel files and restructure data intelligently. The tutorial highlights the simplicity of exporting Excel files into multiple formats, including XLS, TSV, CSV, JSON, XML, and HTML, using the SaveAs method. Specialized methods ensure clean conversion for CSV, JSON, and XML formats, while HTML transformation enhances data presentation. By running the program, users witness IronXL's prowess in crafting and transforming Excel files into various formats. The tutorial underscores the endless possibilities for creating reports, sharing data, and making presentations. It also mentions IronXL's compatibility with interop and additional transformation features. Viewers are encouraged to explore further through the provided link for more data type conversions and to try a trial subscription of IronXL. As always, feedback through likes and subscriptions is welcomed for more insightful tutorials.

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 Copy Cell Content in Excel in C#

NEXT >
How to Export Excel Data Using C#