EasyXLS

Convert XML file to Excel XLSX, XLS or XLSB

Concept

EasyXLS™ library allows you to import data from XML file to Excel.

EasyXLS can be successfully used inclusively to convert large XML files to Excel, XML files with big volume of data with fast conversion time.

EasyXLS permits you to convert XML to Excel file without Excel installed, without Interop or any other additional software installed.

The Excel library allows converting any XML to Excel, but for the best result, a schema similar with EasyXLS.xsd should be used. It is preferable to contain data in a table format simulating the rows and columns, like in the mentioned schema or like an HTML table and CDATA tag should mention EasyXLS word. The tags like table, row and data can be named differently, but the table alike format is important.

EasyXLS also allows converting XML Spreadsheet file to Excel XLSX, XLS or XLSB file format.

The conversion is made in two steps. First, the XML file is imported and after that, the data is exported to Excel file. Once the XML was loaded in memory, optionally, the user can process data, add more features (like formulas, cell formatting, comments, hyperlinks, images, data validations, page setup, charts, so on) and save the file back in any Excel format like XLSX, XLS or XLSB file format.

Concept in action

The below example is a common code about how to convert XML string to Excel.

Source code sample

C#.NET
VB.NET
C++.NET
J#.NET
Java
PHP
ASP
C++
VB6
VBS
Coldfusion

Convert XML to XLSX

EasyXLS allows you to convert XML to Excel XLSX file. The above code sample shows how to achieve this goal, by using ExcelDocument.easy_WriteXLSXFile method.

Convert XML to XLSB

EasyXLS allows you to convert XML to Excel XLSB file. Similarly, as shown in the above code sample, using ExcelDocument.easy_WriteXLSBFile method, the XML file can be converted to XLSB file.

Convert XML to XLS

EasyXLS allows you to convert XML to Excel XLS file. Similarly, as shown in the above code sample, using ExcelDocument.easy_WriteXLSFile method, the XML file can be converted to XLS file.

Convert XML string to Excel

EasyXLS library allows importing data from XML string to Excel using ExcelWorksheet.easy_insertXMLFromString method. The above code sample shows how to achieve this goal.

Convert XML file to Excel

EasyXLS library allows importing data from XML file using ExcelWorksheet.easy_insertXMLFromFile method similarly, as presented in the above code sample.

Convert XML Spreadsheet file to Excel

EasyXLS allows you to convert XML Spreadsheet to Excel XLSX, XLS or XLSB file.

Source code sample

C#.NET
VB.NET
C++.NET
J#.NET
Java
PHP
ASP
C++
VB6
VBS
Coldfusion

Getting started with EasyXLS Excel library

To download the trial version of EasyXLS Excel Library, press the below button:

Download EasyXLS™ Excel Library for .NET and Java

If you already own a license key, you may login and download EasyXLS from your account.



Available for: Professional
Go to top

EasyXLS Excel libraries:

.NET
.NET Excel Library
full .NET version to import, export or convert Excel files
COM+ Excel Component
full COM+ version to import, export or convert Excel files
-
Java
Java Excel Library
full Java version to import, export or convert Excel files
Download EasyXLS™ Excel Library for .NET and Java

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2010
MS Excel 2013
MS Excel 2016
MS Excel 2019
XLSX XLSM XLSB XLS
XML HTML CSV TXT