EasyXLS

Create sheets

EasyXLS™ library allows you to create Excel files with multiple sheets. There are two types of sheets: worksheets and chart sheets.

EasyXLS library 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

Create worksheet

A worksheet is a sheet that contains a grid that consists of cells that are organized in rows and columns. The corresponding class in the library is ExcelWorksheet class.

The below source code sample shows how to export an Excel file with multiple sheets.

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

The screen shot provides an example of an Excel file that has multiple sheets.

Created Excel file with multiple sheets

Create chart sheet

A chart sheet is a sheet that contains a graph. The corresponding class in the library is ExcelChartSheet class.

The below source code sample shows how to export an Excel file having one worksheet and one chart sheet.

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

The screen shot provides an example of an Excel file that has a worksheet and a chart sheet.

Created Excel file with worksheet and chart sheet

Insert sheets into workbook

In addition to appending a sheet, a worksheet or a chart sheet can be inserted between other sheets. The below source code sample shows how to insert a worksheet after the first sheet.

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

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
COM+ Excel Library
full COM+ version to import, export or convert Excel files
COM+ Excel Writer
COM+ version to create and export 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
Download EasyXLS™ Excel Library for .NET and Java

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2019
MS Excel 2021
Office 365
XLSXXLSMXLSBXLS
XMLHTMLCSVTXT