EasyXLS

Import XML Spreadsheet file in .NET, Java and other programming languages

Concept

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

An XML Spreadsheet file is an XML file in a format designed by Microsoft specifically for Excel worksheets.

For more technical information about XML spreadsheets you can check XML Spreadsheet Reference web page.

Concept in action

The below example is a common code about how to import an XML Spreadsheet Excel file.

Source code sample

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

Read XML Spreadsheet file into DataTable in C# and VB.NET

EasyXLS library can be used to import XML Spreadsheet file into DataTable. The DataTable can be the used as data source of a GridView, DataGridView, DataGrid or for any other purposes.

The data from the XML Spreadsheet file can be read using ExcelDocument.easy_ReadXMLSpreadsheet_AsDataSet method and then the DataTable can be obtained from the imported DataSet.

Read XML Spreadsheet file into GridView in C# and VB.NET from ASP.NET

EasyXLS library can be used to import XML Spreadsheet data into GridView from ASP.NET web applications.

The data from the XML Spreadsheet file file can be read using ExcelDocument.easy_ReadXMLSpreadsheet_AsDataSet method and then the DataTable for the GridView can be obtained from the imported DataSet.

Read XML Spreadsheet file into DataGridView in C# and VB.NET

EasyXLS library can be used to import XML Spreadsheet data into DataGridView from windows applications and windows forms.

The data from the XML Spreadsheet file can be read using ExcelDocument.easy_ReadXMLSpreadsheet_AsDataSet method and then the DataTable for the DataGridView can be obtained from the imported DataSet.

Read XML Spreadsheet file into DataSet in C# and VB.NET

EasyXLS library can be used to import XML Spreadsheet file into DataSet from windows applications, ASP.NET pages or console applications.

The data from the XML Spreadsheet file can be read using ExcelDocument.easy_ReadXMLSpreadsheet_AsDataSet method.

Read XML Spreadsheet file into ResultSet in Java

EasyXLS library can be used to import XML Spreadsheet file into ResultSet from Java applications.

The data from the CSV file can be read using ExcelDocument.easy_ReadXMLSpreadsheet_AsResultSet method.

Read XML Spreadsheet file into list

EasyXLS library can be used to import XML Spreadsheet file into lists of data.

The data from the XML Spreadsheet file can be read using ExcelDocument.easy_ReadXMLSpreadsheet_AsList method.

Read XML Spreadsheet file into DataGrid in C# and VB.NET

EasyXLS library can be used to import XML Spreadsheet data into DataGrid from windows applications and windows forms.

The data from the XML Spreadsheet file can be read using ExcelDocument.easy_ReadXMLSpreadsheet_AsDataSet method and then the DataTable for the DataGrid can be obtained from the imported DataSet.

Import XML files

EasyXLS allows you to insert data from XML files or XML strings that are in specific XML schema.

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, Excel Reader

Go to top

EasyXLS Excel libraries:

.NET
.NET Excel Library
full .NET version to import, export or convert Excel files
.NET Excel Reader
.NET version to read and import Excel files
-
Java
Java Excel Library
full Java version to import, export or convert Excel files
Java Excel Reader
Java version to read and import 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
XLSXXLSMXLSBXLS
XMLHTMLCSVTXT