The C# Excel Library

Read Excel Files without Interop

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);

Install-Package IronXL.Excel

IronXL Blog - Page 5

January 27, 2024

How to Import an Excel File to SQL Database in VB .NET

In this article, we are going to see how VB .NET imports Excel files into the SQL Server database table without using the provider Microsoft.ace.oledb 12.0 data.

Ironxl Blog 375w 211h related to IronXL Blog - Page 5

January 27, 2024

How to Import CSV To Datatable in C#

January 27, 2024

How to Read Data From CSV File And Store It In Database C#

This tutorial covers the steps to read data from a CSV file and store it in an SQL Server Database using C#, specifically utilizing the IronXL library

January 27, 2024

How to Convert CSV File Into List in C#

In this tutorial for beginners, we are going to see how to read CSV files into a list in C# using the IronXL

January 27, 2024

How to Export Datagridview To Excel in C#

This tutorial provides a comprehensive guide on how to export data from a DataGridView control in a Windows Forms Application to an Excel file using the IronXL library in C#

January 14, 2024

Comparing Three Open Source C# Excel Libraries

This article will explore three C# Open Source Excel libraries designed to simplify Excel file manipulation in a .NET environment

January 14, 2024

Work with Excel Files Without Microsoft Office in C#

This makes it a go-to solution for server environments where installing Microsoft Office is not feasible due to licensing or server performance constraints.

January 14, 2024

C# Excel Automation (Developer Tutorial)

In this article, we are going to see more about Excel automation in C#

January 4, 2024

How to Concatenate or Merge Excel Files in C# Combine XLS

IronXL is a powerful Excel library that can be used to perform various types of Excel operations. In this article, we are going learn how to concatenate or merge Excel files in C# combine xls.

January 4, 2024

How to Convert Excel to Datatable in C# Without oledb

In this article, we are going to convert Excel to datatable in C# without OLEDB connectivity.

January 4, 2024

Test Your Regex Patterns with .NET Regex Tester

This article delves into the capabilities of .NET Regex Tester, providing insights and examples into its usage and integration with IronXL

November 22, 2023

How to Write A CSV File in C#

In this article, we will see how to write CSV files using a C# library named IronXL in a new project.

November 22, 2023

How to Load An Excel File in C#

This article will demonstrate how to load Excel files using IronXL, a first-class Excel C# library, efficiently and programmatically.

November 22, 2023

How to Export to CSV in .NET Core

This article outlines the process of utilizing a .NET Core application to establish a framework for efficiently managing Excel spreadsheets, including reading and exporting to CSV format.

November 22, 2023

C# CSV Library (Developer Tutorial)

In this article, we will explore C# programming using IronXL's features for efficiently working with CSV files.

November 14, 2023

How to Edit a Spreadsheet in C#

This article explores spreadsheet manipulation in C# using IronXL, an advanced data manipulation library, without relying on user interface interactions.

November 14, 2023

How to Save A CSV File in C#

In this article, we will use IronXL's market-leading data manipulation library to save spreadsheets as CSV files and modify data in the transformation process.

November 14, 2023

How to Export File to CSV in C#

IronXL, a first-class C# library that offers a wide range of features to read and export Excel spreadsheets to CSV files.

November 14, 2023

How to Export to Excel With Formatting in C#

In this article, we'll discuss methods for exporting data from a CSV file to visually engaging Excel spreadsheets with cell stylings using IronXL.

November 13, 2023

How to Work With Excel Files Using IronXL: A .NET Excel Library

The C# IronXL library, a .NET Excel tool, allows users to read and convert Microsoft Excel documents to CSV files efficiently and programmatically.

November 1, 2023

Tutorial A Comparison Between IronXL and ClosedXML 1

Learn the differences between IronXL and ClosedXML to make an informed decision for your project needs. This video provides a detailed comparison of both tools, covering features, performance, and ease of use, helping you select the most suitable option for handling Excel files efficiently.

November 1, 2023

A Comparison Between IronXL and ClosedXML

This video compares Iron XL and Close XML, two popular .NET libraries for reading Excel files. It demonstrates the differences in complexity and versatility, highlighting Iron XL's broader file compatibility and straightforward approach compared to Close XML's Excel-specific capabilities.

September 14, 2023

How to Write an Excel File in C#

This tutorial video guides you through reading and writing Excel files using IronXL in C#. Learn to manipulate Excel data efficiently in Visual Studio 2022. The video covers setting up the environment, reading data, validating formulas, and saving modified files.