EasyXLS

Create Excel file in .NET, Java and other programming languages

Concept

EasyXLS™ library allows you to create Excel documents. The data in cells can be formatted using predefined formats or user-defined formats.

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

The first step is to create an instance of the ExcelDocument class, which is the main class for pure code-based Excel document handling. This class is the key used to create new Excel files and read Excel files.

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

It also provides a method, easy_getError, for debugging purposes, which renders information on errors or warnings that occur during writing or reading Excel files.

Concept in action

The below example shows how to create Excel file programmatically. After that, more code samples about how to create and save Excel file from various standard data structures like DataTable, DataSet, ResultSet and List are shown.
The source code samples can be integrated in:
- ASP.NET web pages
- Windows applications
- Windows Forms (WinForms)
- Console applications
- Windows service applications
- ASP.NET MVC web applications
- PHP and ASP web pages
- Java applications

Source code sample

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

The screen shot below represents the created Excel document generated by the code sample above. The file has two worksheets (First Tab and Second Tab).

Created Excel file programmatically

Create Excel sheet

EasyXLS™ enables you create new Excel sheets.

Add data into sheets

EasyXLS™ enables you to populate the sheets with data. The supported data types are strings, numbers, dates, booleans, errors and formulas.

Create Excel file from DataTable in C# and VB.NET

EasyXLS allows you to create Excel file from DataTable. The data can be arranged in nice formatted reports.

Create Excel file from DataSet in C# and VB.NET

EasyXLS allows you to create Excel file from DataSet. The data can be arranged in nice formatted reports.

Create Excel file from list

EasyXLS allows to create formatted Excel file from list of data.

Create Excel file from GridView in C# and VB.NET from ASP.NET

EasyXLS allows you to create formatted Excel file from GridView.

Create Excel file from DataGridView in C# and VB.NET

EasyXLS allows you to create formatted Excel file from DataGridView.

Create Excel file from ResultSet in Java

EasyXLS allows you to create Excel file from ResultSet. The data can be arranged in nice formatted reports.

Create XLSX, XLSB, XLSM and XLS files

This code sample shows how to create XLS file. In a similar way, you can create XLSX file using ExcelDocument.easy_WriteXLSXFile method or create XLSB file using ExcelDocument.easy_WriteXLSBFile 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
MS Excel 2003
MS Excel 2007
MS Excel 2010
MS Excel 2013
MS Excel 2016
XLS XLSX XLSM XLSB
XML HTML CSV TXT