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

Using IronXL

September 29, 2024

How to Manage Excel Ranges in C#

In this tutorial, we will focus on working with Excel ranges using IronXL. We'll cover how to write, read, and manipulate ranges within an Excel file.

September 29, 2024

How to Work with Excel Files in C#

Working with Microsoft Excel files in programming languages has become a significant requirement in today's modern programming paradigm

July 1, 2024

How to Import Excel to SQL Server in C#

In many different business contexts, importing data from Excel into SQL Server is a typical necessity. Reading data from an Excel file and entering it into a SQL Server database are the tasks involved in this activity

April 29, 2024

How to Autofit Cells in Excel Using C#

In this article, we will learn how to autofit column width and height in Excel using C# and IronXL.

April 29, 2024

How to parse an Excel file in Python

We will examine how to parse an Excel file in Python using IronXL in this in-depth tutorial.

April 29, 2024

How to Create a new Excel Workbook in C#

We'll walk through the necessary steps, from setting up your development environment to writing the code that generates a new Excel workbook.

April 29, 2024

How to Use C# Excel Font Style

However, this option isn't as flexible or convenient as alternative _solutions._ Hence, this post will discuss using IronXL, on how to use C# Excel to set font style.

April 29, 2024

How to Rename Excel WorkSheet in C#

In this article, we'll explore how to rename Excel files using IronXL library from IronSoftware.

April 3, 2024

How to Read an Excel File in a C# Console Application

This article will guide you through the process of reading Excel files in a C# Console Application using the IronXL library

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 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 An Excel File to XML in C#

It is an essential tool for organizing, evaluating, and using data to inform choices. In the article, we are going to learn how to convert Excel to XML in C#.

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.

January 27, 2024

How to Import CSV To Datatable in C#

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 Save An Excel File in VB .NET

In this article, we're going to look at how you can use VB.NET to save Excel files with the help of IronXL.

January 14, 2024

C# Excel Automation (Developer Tutorial)

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

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 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.

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