The C# Excel Library
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
This article will explore the IronXL library to convert XLS to XLSX format in a C# Console Application.
IronXL is a .NET Excel Library that helps developers create, read, and edit Excel files in C# applications. It is fast and accurate regarding performance and output, respectively. It supports all Excel workbook file formats (XLS, XLSX, XLSM, CSV, TSV). IronXL also allows data to be saved or exported from Excel formats (XLS, XLSX) to JSON, HTML, Binary, Byte Array, DataSet, or DataTable.
IronXL allows developers to work with worksheets and cell ranges elegantly. With IronXL, you can edit formulas. Recalculation of the already given formula in the sheet is very easy to do. Data can be sorted based on range, column, or row. It provides you the facility to edit layouts like freeze panes, auto-size rows/columns, and add and remove rows/columns easily.
With IronXL, Excel files can be protected with a user password and permission to edit the file. Another feature is that you can add, remove, and extract images from Excel worksheets. It also provides a wide range of Excel functions with almost all cell data formats. This makes IronXL one of the most intuitive APIs when it comes to working with Excel files.
IronXL does not need Microsoft Excel to be installed on the machine as it does not require Office Interop or any other dependency. It works on multiple platforms and is compatible with .NET 7, 6 & 5. It also supports .NET Core 2 and 3 along with the standard 2 versions. .NET Framework 4.5 and onwards is also supported for working on Excel spreadsheets.
The latest version of Visual Studio is recommended for creating an application to start with. Visual Studio is the official IDE for C# development, and you must have it installed. You can download it from the Microsoft Visual Studio website if it's not already installed.
The following steps will create a new project named "DemoApp".
Open Visual Studio and click on "Create a New Project".
Open Visual Studio
Select "Console Application" and Click "Next".
Create a new project in Visual Studio
Set the name of the Project.
Configure your new project
Select the .NET version. Choose the stable version, .NET 6.0.
.NET Framework selection
Once the project is created, the IronXL library needs to be installed in the project for use. Follow these steps to install it.
Open "Manage NuGet Packages for Solutions" either from Solution Explorer or Tools.
Navigate to NuGet Package Manager
Browse for the IronXL Library and select the current project. Click install.
Search and install the IronXL package in NuGet Package Manager UI
Add the following namespace at the top of the Program.cs file:
using IronXL;using IronXL;Imports IronXLIronXL provides the facility to open an existing Excel file, or you can create a new Excel file. Here we are going to open an existing Excel XLS file using the C# IronXL LoadExcel method. The Load method is a short synonym for LoadExcel.
// Load an existing Excel file. Supported formats include XLSX, XLS, XLSM, XLTX, CSV and TSV.
WorkBook workBook = WorkBook.LoadExcel("sample.xls");// Load an existing Excel file. Supported formats include XLSX, XLS, XLSM, XLTX, CSV and TSV.
WorkBook workBook = WorkBook.LoadExcel("sample.xls");' Load an existing Excel file. Supported formats include XLSX, XLS, XLSM, XLTX, CSV and TSV.
Dim workBook As WorkBook = WorkBook.LoadExcel("sample.xls")The sample file loaded is as follows:
A sample XLS data file
To create Excel files in XLS or XLSX format, you can visit this code examples page here.
To convert an XLS to an XLSX file, IronXL just uses the SaveAs method to do this conversion. The following code shows how to save an XLS file to an XLSX file:
// Convert XLS to XLSX format by saving it with a different file extension.
workBook.SaveAs("converted_sample.xlsx");// Convert XLS to XLSX format by saving it with a different file extension.
workBook.SaveAs("converted_sample.xlsx");' Convert XLS to XLSX format by saving it with a different file extension.
workBook.SaveAs("converted_sample.xlsx")That's it. We have successfully converted an XLS to XLSX format. To convert to other formats, you can visit this code examples page.
The exported XLSX file
You can see that the data is the same even after conversion. IronXL provides ease of use, speed, and accuracy.
This article demonstrated how to convert XLS Excel files to XLSX files using IronXL in C#. IronXL provides the facility to work with existing Excel files without any hassle. Conversion between different spreadsheet formats is usually a one-line process. It's fast, easy to use, and accurate. It also allows you to create new Excel files and write data to them with easy syntax. IronXL can also be used to read Excel files without Microsoft Office installed. To read data from Excel files, you can see this code example page.
IronXL is free for development and can be licensed for commercial use. You can also try IronXL for a free trial for commercial use. Download the software from the IronXL website.
IronXL is a .NET Excel Library that helps developers create, read, and edit Excel files in C# applications. It supports all Excel workbook file formats and allows data export to various formats.
No, IronXL does not require Microsoft Excel to be installed on the machine. It works without Office Interop or any other dependency.
IronXL is compatible with .NET 7, 6 & 5, .NET Core 2 and 3, and .NET Framework 4.5 and onwards.
To convert an XLS to an XLSX file using IronXL, load the XLS file using the LoadExcel method and then save it as an XLSX file using the SaveAs method.
Yes, IronXL allows developers to edit Excel files, including editing formulas, sorting data, and modifying layouts such as freezing panes and resizing rows or columns.
IronXL is free for development use. For commercial use, it requires a license, but a free trial is available.
You can install the IronXL library via NuGet Package Manager in Visual Studio by searching for the IronXL package and selecting it for your project.
Yes, IronXL supports various Excel file formats including XLS, XLSX, XLSM, CSV, and TSV.
To use IronXL in a C# project, you need to have Visual Studio installed, create a new Console Application, and install the IronXL library via NuGet Package Manager.
Install-Package IronXL.Excel
No credit card required
Your trial key should be in the email.
The trial form was submitted
successfully.
If it is not, please contact
support@ironsoftware.com
No credit card required
Get started for FREE
No credit card required
Test in production without watermarks.
Works wherever you need it to.
Get 30 days of fully functional product.
Have it up and running in minutes.
Full access to our support engineering team during your product trial
No credit card or account creation required
Your trial key should be in the email.
If it is not, please contact
support@ironsoftware.com
Get started for FREE
No credit card required
Test in production without watermarks.
Works wherever you need it to.
Get 30 days of fully functional product.
Have it up and running in minutes.
Full access to our support engineering team during your product trial
Licenses from $749. Have a question? Get in touch.
Book a 30-minute, personal demo.
No contract, no card details, no commitments.
10 .NET API products for your office documents
