EasyXLS

Predefined formatting for cell ranges

EasyXLS™ library provides 49 predefined auto formats for generating nice reports, including Excel auto formats and some extra auto formats.

Using those predefined formats the user can automatically design the report header, footer, left column, right column, odd/even stripes and report data.

Format options for an auto format

An auto format includes settings for:

- Cell text format: number format, currency format, date format, accounting format, percentage format, fraction format, text format and other custom formats
- Cell alignment: horizontal and vertical alignment, text indentation, wrap text and shrink options, merge cells, text rotation and text direction
- Cell font settings: font name, font size, foreground, bold ant italic options, underline style, strikethrough, superscript and subscript effects
- Cell border: border line style and color
- Cell fill settings: background color, pattern style, pattern color, gradient fill
- Cell protection: locked cells and hidden formulas

Autoformat for data structures

The autoformat can be applied along with data structures like DataSet, ResultSet or List. The below source code sample shows how to export an Excel file with a predefined cell formatting applied.

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

The screen shot below represents the exported Excel file with a predefined cell range formatting applied.

Exported Excel file with predefined formatting on cell range

Autoformat for Excel file with multiple sheets

EasyXLS offers the option to insert multiple data structures like DataTable, DataSet, ResultSet or List into one worksheet or into multiple worksheets. The data structure can be added into a specified worksheet. The column names of the data structure can be optionally included.

Autoformat for cell ranges

EasyXLS allows you to set an autoformat for a range of cells using ExcelTable.easy_setRangeAutoFormat method.

The below source code sample shows how to apply a nice table formatting on A1:D10 cell range.

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

Autoformat position

EasyXLS allows you to set where the autoformat will be placed on the worksheet. All the methods that set the autoformat have method variants that permits to set the cell start position for the table autoformat.

The below source code sample shows how to insert a data structure with autoformat starting from A2 cell.

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

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

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