EasyXLS

Create sheets

Concept

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

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.

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

Concept in action

The below example shows how to export an Excel file with multiple sheets: one worksheet and one chart sheet. Similarly, you can add more than one worksheet and more than one chart sheet.

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 provides an example of an Excel file that has multiple sheets.

Created Excel file with multiple sheets


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