EasyXLS | 

Excel library to import or export data to Excel files

Programmer's Guide API Documentation  


Cell values

Concept

EasyXLS™

library allows you to export data to Excel file. It enables the user to set the cell values and the data type of the cell by using the simple methods from ExcelCell class.

The default data type for the cells can be determined automatically, but we recommend using a defined one such as string, numeric, date, boolean or error because the use of an automatic data type can be resource and time consuming when exporting large Excel files.

EasyXLS also allows to import data from Excel file. The cell values can be accessed by using methods from ExcelCell class.

The component supports the following data types:

String values

A string value is any finite sequence of characters (i.e., letters, numerals, symbols and punctuation marks).

Numeric values

A numeric value can be an integer, float or double number. The numeric values can be formatted with currency format, date format, accounting format, percentage format, fraction format or any custom format.

Date values

A date value is a calendar date that can include also the time. We recommend entering the date values in "MM/dd/yyyy HH:mm:ss" format (i.e. 12/23/2005 22:45:21) for optimization purposes. Later, to apply a different format, the cell can be formatted using the desired date format.

Boolean values

A boolean value can be a "true" or "false" value.

Error values

An error value is a specific error value from Excel (i.e. #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL!).

Formula values

A formula value is a mathematical expression that allows calculations for worksheets values.

Concept in action

The below example shows how to export data to Excel file.

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 exported data to Excel 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 Excel file

Export data to Excel file

EasyXLS allows you to export data to Excel file. The above code sample shows how to achieve this goal.

Import data from Excel file

EasyXLS allows you to import data from Excel file. The library permits reading cell values including formula results.

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


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
XLS XLSX XLSM XLSB
XML HTML CSV TXT