EasyXLS

Export XML Spreadsheet file

Concept

EasyXLS™ library allows you to export data to XML Spreadsheet Excel file format. The data in cells can be formatted using predefined formats or user-defined formats.

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.

The entire workbook can be saved as an XML Spreadsheet file (with some limitation applied to visual objects such as images, charts or drawings) and after that it can be processed as any other XML file or you can open it with Microsoft Excel.

Concept in action

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

Source code sample

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

The screen shot below represents the exported data to XML Spreadsheet file generated by the code sample above. The file has two worksheets (First Tab and Second Tab). The values and the data type of the cells from the first worksheet are set.

Exported data to XML Spreadsheet Excel file

Formatting cells

EasyXLS™ enables you to format cells, rows and columns in order to set the fonts and colors.

Export DataTable to XML in C# and VB.NET

EasyXLS allows exporting DataTable to XML file. The DataTable can be inserted using ExcelWorksheet.easy_insertDataSet method and the XML file must be exported using ExcelDocument.easy_WriteXMLFile method.

Export GridView to XML in C# and VB.NET from ASP.NET

EasyXLS allows exporting GridView to XML file. The DataTable of the GridView can be inserted using ExcelWorksheet.easy_insertDataSet method and the XML file must be exported using ExcelDocument.easy_ WriteXMLFile method.

Export DataGridView to XML in C# and VB.NET

EasyXLS allows exporting DataGridView to XML file. The DataTable of the DataGridView can be inserted using ExcelWorksheet.easy_insertDataSet method and the XML file must be exported using ExcelDocument.easy_ WriteXMLFile method.

Export DataSet to XML in C# and VB.NET

EasyXLS allows exporting DataSet to XML file. The DataSet can be inserted using ExcelWorksheet.easy_insertDataSet method and the XML file must be exported using ExcelDocument.easy_ WriteXMLFile method.

Export ResultSet to XML in Java

EasyXLS allows exporting ResultSet to XML file. The ResultSet can be inserted using ExcelWorksheet.easy_insertResultSet method and the XML file must be exported using ExcelDocument.easy_WriteXMLFile method.

Export list to XML

EasyXLS allows exporting list to XML file. The list can be inserted using ExcelWorksheet.easy_insertList method and the XML file must be exported using ExcelDocument.easy_WriteXMLFile method.

Export DataGrid to XML in C# and VB.NET

EasyXLS allows exporting DataGrid to XML file. The DataTable of the DataGrid can be inserted using ExcelWorksheet.easy_insertDataSet method and the XML file must be exported using ExcelDocument.easy_WriteXMLFile method.

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 Writer
Go to top

EasyXLS Excel libraries:

.NET
.NET Excel Library
full .NET version to import, export or convert Excel files
.NET Excel Writer
.NET version to create and export 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 Writer
Java version to create and export 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
XLSX XLSM XLSB XLS
XML HTML CSV TXT