EasyXLS

Groups and outline levels

Concept

EasyXLS™ library allows you to group data on rows and columns, so that the user can show/hide data. The data is organized in levels. The outline levels are determined automatically, based on the group data range.

Concept in action

The below example shows how to group data on the first sheet of an Excel file on two outline levels.

Source code sample

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

The screen shot below represents an Excel report that includes a data group that has two outline levels of details for its data.

Excel groups, Excel outline levels

Data group settings

EasyXLS enables you to set the direction settings, to summary rows below detail using ExcelWorksheet.setDataGroupSummaryRowsBelow method and to summary columns to right of detail using ExcelWorksheet.setDataGroupSummaryColumnsRight method.

EasyXLS allows you to set the automatic styles for data using ExcelWorksheet.setDataGroupAutomaticStyles method.

Formatting group data

EasyXLS enables you format the data inside the group range of cells using automatic styles.

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.


 
 

Available for: Professional, Excel Writer, Excel Reader
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