EasyXLS

Export List to Excel file in .NET, Java and other programming languages

Concept

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

EasyXLS can be successfully used inclusively to export large Excel files having big volume of data with fast exporting time.

The list must contain the rows, each row being an EasyXLS.Util.List object containing the cell values. EasyXLS.Util.List extends System.Collections.ArrayList for .NET version and java.util.Vector for Java version.

EasyXLS permits you to export Excel files without Excel installed, without Interop or any other additional software installed.

Concept in action

The below example shows how to export list to Excel in .NET, Java and export lists of data extracted from database in PHP, ASP, C++, VB6, VBS and Coldfusion.

Source code sample

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

The screen shot below provides an example of an exported Excel file from a list.

Exported data to Excel file from List

Formatting cells

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

Export List to XLSX, XLSB, XLSM and XLS files

This code sample shows how to export a list to an XLS file. In a similar way, you can export a List to XLSX file using ExcelDocument.easy_WriteXLSXFile_FromList method or export a List to XLSB file using ExcelDocument.easy_WriteXLSBFile_FromList method.

Export List to Excel file with multiple sheets

For an Excel file having multiple sheets, the List can be inserted using ExcelWorksheet.easy_insertList method and the Excel file must be exported using ExcelDocument.easy_WriteXLSFile 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, Express 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 Express Excel Writer
limited .NET version to create and export Excel files in predefined formats
-
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 Express Excel Writer
limited Java version to create and export Excel files in predefined formats
Download EasyXLS™ Excel Library for .NET and Java

File formats:

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