How to Convert xls to xlsx in C#
Maintaining up-to-date technology is essential for smooth data handling in today's fast-paced environment. The latest XLSX format offers more functionality than the XLS (Excel 97-2003) format. By converting XLS documents to XLSX format, you may stay away from compatibility problems and discover additional Excel capabilities. This is where the Syncfusion Excel Library comes in handy, making conversion simple to accomplish.
The Syncfusion Excel Library, also called Essential XlsIO, simplifies creation, reading, and editing Excel documents using C#. The program facilitates the generation of new Excel documents, editing existing ones, data import and export, Excel formulas, conditional formats, data validations, sparklines, charts, tables, pivot tables, pivot charts, template markers, and various other features.
One of the primary features of the Syncfusion Excel Library is the ability to open and convert XLS files to XLSX format with a few lines of code.
You may quickly and easily convert XLS to XLSX programmatically using a few lines of code by with the.NET library. Aspose.Cells for.NET can be used to create cross-platform apps that can create, edit, convert, render, and print any Excel file. Excel files can be rendered in various formats such as pictures, PDFs, HTML, ODS, CSV, SVG, JSON, WORD, PPT, and more using the.NET Excel API, which makes it an ideal option for exchanging documents in industry-standard formats.
XLS format:
The Excel Binary File Format is represented by files ending in.XLS. These kinds of files can be produced by spreadsheet programs like Apple Numbers and OpenOffice Calc, as well as by Microsoft Excel. Excel saves files under the name "Workbooks," each of which may contain one or more worksheets. Worksheets contain and present data to users in table format. This data can include text, formulas, external data connections, photos, charts, and numeric values. Workbook data can be exported from programs like Microsoft Excel to several other formats, such as PDF, CSV, XLSX, TXT, HTML, and XPS.
With the release of Microsoft Excel 2007, the more open and structured XLSX file format took the place of the earlier XLS file format. The latest versions still allow you to create and read XLS files, but XLSX is now the preferred format.
Xlsx Format:
With the release of Microsoft Office 2007, Microsoft introduced the widely recognized XLSX format for Microsoft Excel documents. The new format, which consists of a zip package containing many XML files, is based on a structure arranged in accordance with the Open Packaging Conventions as described in Part 2 of the OOXML standard ET-3806. Just unzipping the.xlsx file will reveal the underlying structure and files for inspection.
System requirements for converting XLS to XLSX:
Be sure you have the following requirements before executing the.NET conversion example code.
- Microsoft Windows or an OS that is compatible with the Mono, Windows Azure, or .NET Core platforms.
- An environment for development like Microsoft Visual Studio.
- In your project, include a reference to the Aspose.Cells for.NET DLL.
Steps for converting xls to xlsx:
Step 1: Create a new core console application for.NET.
Start by opening Visual Studio and creating a new.NET Core console application.
![How to Convert xls to xlsx in C#/>
<!-- /wp:html -->
<!-- wp:paragraph -->
<p><strong>Step 2: Set up and install the Excel Library.</strong></p>
<!-- /wp:paragraph -->
<!-- wp:paragraph -->
<p>Next, integrate the NuGet package Syncfusion.XlsIO.Net.Core into your application.</p>
<!-- /wp:paragraph -->
<!-- wp:paragraph -->
<p><strong>Step 3: XLS to XLSX format conversion</strong></p>
<!-- /wp:paragraph -->
<!-- wp:paragraph -->
<p>Finally, to convert an XLS file from a specified folder path to an XLSX document, implement the following code in the Program.cs file.</p>
<!-- /wp:paragraph -->
<!-- wp:preformatted -->
<pre class=](https://static.tutorialandexample.com/csharp/how-to-convert-xls-to-xlsx-in-csharp1.png)
using System;
using System.IO;
namespace ExcelConverter
{
class Program
{
private static string inputPath = @"../../../Data/";
private static string outputPath = @"../../../Output/";
static void Main(string[] args)
{
string fileName = "Report.xls";
ConvertExcelToXLSX(inputPath + fileName);
}
private static void ConvertExcelToXLSX(string filePath)
{
FileStream inputData = new FileStream(filePath, FileMode.Open, FileAccess.ReadWrite);
using (ExcelEngine excelEngine = new ExcelEngine())
{
IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Xlsx;
IWorkbook workbook = application.Workbooks.Open(inputData);
IWorksheets worksheets = workbook.Worksheets;
workbook.Version = ExcelVersion.Xlsx;
FileStream fileStream = new FileStream(outputPath + Path.GetFileNameWithoutExtension(filePath) + ".xlsx", FileMode.Create, FileAccess.ReadWrite);
workbook.SaveAs(fileStream);
fileStream.Close();
}
}
}
}
The input file for this is the xls document:
![How to Convert xls to xlsx in C#/>
<!-- /wp:html -->
<!-- wp:paragraph -->
<p><strong>Output: </strong>Output is in the xlsx format</p>
<!-- /wp:paragraph -->
<!-- wp:html -->
<img src=](https://static.tutorialandexample.com/csharp/how-to-convert-xls-to-xlsx-in-csharp2.png)
I appreciate your reading! In this tutorial, we looked at using the Syncfusion Excel Library (XlsIO) to convert XLS files to XLSX documents in C#. The Excel Library can also export Excel data as PDF, pictures, data tables, CSV, TSV, HTML, collections of objects, ODS, JSON, and other file formats.