EasyXLS

Freeze and split panes

Concept

EasyXLS™ library allows you to freeze worksheet panes for Excel files. The library permits you to freeze the report column headers for an Excel report, for example.

This Excel component also allows you to split worksheet panes for Excel files. By choosing the split option the worksheet is split in two views.

Concept in action

The below example shows how to freeze the first row of a worksheet, when a report is exported to Excel file.

Source code sample

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

The screen shot below represents an exported Excel report with freeze panes.

Excel freeze panes, Excel split panes

Freeze panes

EasyXLS enables you freeze panes for an Excel worksheet by using ExcelTable.easy_freezePanes method. The above code sample shows how to achieve this goal.

Split panes

EasyXLS enables you split panes for an Excel worksheet by using ExcelTable.easy_split method.

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.

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