C# Tutorial

C# Tutorial C# First Application C# Variables C# Data Types C# Operators C# Keywords

C# Control Statement

C# If Statements C# Switch Statements C# for Loop C# While Loop C# do While loop C# Jump Statements C# Function C# functions with out variable

C# Arrays

C# Arrays

C# Function

C# Function call by value C# Call by reference C# Passing array to function C# Multidimensional Arrays C# Jagged Arrays C# Params C# Array Class C# Command Line Arguments

C# Object Class

C# Object and Classes C# Constructors C# Destructor C# this Keyword C# static field C# static class C# Static Constructor C# Structs C# enum C# Properties

C# Inheritance

C# Inheritance C# Multilevel Inheritance C# Aggregation C# Member overloading C# Method Overriding C# Base

C# Polymorphism

C# Polymorphism C# Sealed

C# Abstraction

C# Abstraction C# Interface

C# Namespace

C# Namespace C# Access Modifiers C# Encapsulation

C# Strings

C# String

C# Misc

C# Design Patterns Dictionary in C# Boxing and Unboxing in C# Ref and Out in C# Serialization in C# Dispose and Finalize in C# CONSOLE LOG IN C# Get File extension in C# Insert query in c# Difference Between List and Dictionary in C# Getters and Setters in C# Extension Methods in C# Insert query in c# CONSOLE LOG IN C# Get File extension in C# Random.NextDouble() Method in C# Binary Search in C# Difference between Delegates and Interfaces in C# Double.IsFinite() Method in C# Index Constructor in C# Abstraction in C# Basic OOPS Concepts In C# Queue.CopyTo() Method in C# single.compareto() method in C# C# Throw Exception in Constructor DECODE IN C# file.setlastwritetimeutc() method in C# Convert Object to List in C# convert.ToSByte(string, IFormatProvider) Method in C# C# Declare Delegate in Interface console.TreatControl C As Input property in C# Copying the queue elements to 1-D Array in C# Array.Constrainedcopy() Method in C# C# in and out Char.IsLetterOrDigit() method in C# Debugging in C# decimal.compare() method in C# Difference between Console.Read and Console.Readline in C# Metadata in C# C# Event Handler Example Default Interface Methods in C# Difference between hashtable and dictionary in C# C# program to implement IDisposable Interface Encapsulation in C# SortedList.IndexOfVaalue(Object) Method in C# Hash Maps in C# How to clear text files in C# How to Convert xls to xlsx in C# Foreach loop in C# FIFO in C# How to handle null exception in C# Type.Is Instance Of Type() Method in C# How to add data into MySQL database using C# How to use angular js in ASP net Csharp decimal.compare() method in Csharp Difference between Console.Read and Console.Readline in Csharp How to Implement Interface in Csharp char.IsUpper() Method in C# Index Of Any() Method in C# Quantifiers in C# C# program to Get Extension of a Given File C# Error Logging C# ENCRIPTION Can we create an object for Abstract Class in C# Console.CursorVisible in C# SortedDictionary Implementation in C# C# Hash Table with Examples Setting the Location of the Label in c# Collections in c# Virtual Keyword in C# Reverse of string in C# String and StringBuilder in C# Encapsulation in C# SortedList.IndexOfVaalue(Object) Method in C# Hash Maps in C# How to clear text files in C# How to Convert xls to xlsx in C# Foreach loop in C# FIFO in C# How to handle null exception in C# Type.Is Instance Of Type() Method in C# How to add data into MySQL database using C# How to use angular js in ASP net Csharp decimal.compare() method in Csharp Difference between Console.Read and Console.Readline in Csharp How to Implement Interface in Csharp char.IsUpper() Method in C# Index Of Any() Method in C# Quantifiers in C# C# program to Get Extension of a Given File Difference between ref and out in C# Singleton Class in C# Const And Readonly In Csharp BinaryReader and BinaryWriter in C# C# Attributes C# Delegates DirectoryInfo Class in C# Export and Import Excel Data in C# File Class in C# FileInfo Class in C# How to Cancel Parallel Operations in C#? Maximum Degree of Parallelism in C# Parallel Foreach Loop in C# Parallel Invoke in C# StreamReader and StreamWriter in C# TextReader and TextWriter in C# AsQueryable() in C# Basic Database Operations Using C# C# Anonymous Methods C# Events C# Generics C# Indexers C# Multidimensional Indexers C# Multithreading C# New Features C# Overloading of Indexers Difference between delegates and events in C# Operator overloading in C# Filter table in C# C# Queue with Examples C# Sortedlist With Examples C# Stack with Examples C# Unsafe Code File Handling in C# HashSet in C# with Examples List Implementation in C# SortedSet in C# with Examples C# in Depth Delegates and Events in C# Finally Block in C# How to Split String in C# Loggers in C# Nullable Types in C# REVERSE A STRING IN C# TYPE CASTING IN C# What is Generics in C# ABSTRACT CLASS IN C# Application of pointer in C# Await in c# READONLY AND CONSTANT IN C# Type safe in C# Types of Variables in c# Use of delegates in c# ABSTRACT CLASS IN C# Application of pointer in C# Await in c# READONLY AND CONSTANT IN C# Type safe in C# Types of Variables in c# Use of delegates in c# ABSTRACT CLASS IN C# Application of pointer in C# Await in c# READONLY AND CONSTANT IN C# Type safe in C# Types of Variables in c# Use of delegates in c# Atomic Methods Thread Safety and Race Conditions in C# Parallel LINQ in C# Design Principles in C# Difference Between Struct And Class In C# Difference between Abstraction and Encapsulation in C# Escape Sequence Characters in C# What is IOC in C# Multiple Catch blocks in C# Appdomain in C# Call back methods in C# Change Datetime format in C# Declare String array in C# Default Access Specifier in c# Foreach in LINQ C# How to compare two lists in C# How to Convert String to Datetime in c# How to get only Date from DateTime in C# Ispostback in asp net C# JSON OBJECT IN C# JSON STRINGIFY IN C# LAMBDA FUNCTION IN C# LINQ Lambda Expression in C# Microservices in C# MSIL IN C# Reference parameter in C# Shadowing(Method hiding) in C# Solid principles in C# Static Members in C# Task run in C# Transaction scope in C# Type Conversion in c# Unit of Work in C# Unit Test Cases in c# User Defined Exception in c# Using Keyword in C# Var Keyword in C# What is gac in C#

How to Convert xls to xlsx in C#
2024-05-29 06:34:52

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=using Syncfusion.XlsIO;

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=Conclusion:

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.