Overview

Provides a quick overview of the functionalities of excel. The potential usage of XlsIO has been classified under the four categories

Spreadsheet Generation	Extract Data From Spreadsheet
Edit Spreadsheet

Excel 2007 Support

Essential XlsIO has basic support for working with Excel 2007's xlsx format. You can work with all basic operations and same APIs of Biff8 formats.

xlsx support

Cell Styles Support

Formatting

This section explains the formatting capabilities of Essential XlsIO.

Cell Formats	Global Styles
Row and Column Styles	Conditional Formatting
Rich Text	Working With Images
Hyperlinks	Cell Copy

Calculations

Essential XlsIO has advanced support for working with Formulas in cells.

Formula Support

Processing Formulas

Data Manipulation

Essential XlsIO has advanced support for working with Data in a worksheet. Here are some key functionalities that enables working with data easier.

Named Ranges	Import Export DataTable
Range Manipulation	Auto Filters
Data Validation	Find Replace Support

Worksheet Manipulation

Essential XlsIO has advanced support for manipulating the worksheet.

Autofit Rows and Columns	Copy Worksheet
Freeze Pane	Group Ungroup Rows and Columns
Hide Unhide Rows and Columns	Insert rows and columns
PageBreak	RowHeight and ColumnWidth
Preserving Unsupported Elements

Comments

Essential XlsIO has APIs for reading and writing comments for cells in a worksheet.

Working with Comments

Comment Styles

Charts

Essential XlsIO has advanced support for creating and modifying Excel charts inside a workbook. There is an option to choose between creating a chart as an embedded chart or as a worksheet chart.

Chart Types	Chart Look and Feel
Chart In Template

Security

Essential XlsIO has support for securing the content, structure and windows of a Excel workbook and worksheet.

Encryption and Decryption	Workbook Protection
Worksheet Protection

Spreadsheet Property Settings

Essential XlsIO has support for reading and writing the spreadsheet properties.

Header and Footer	Margins
Page SetUp

Performance

Essential XlsIO is known for its high performance for generating Excel files with large number of rows and columns. It has superior performance over MS Excel in the context of report generation processes.

Performance Measures