Overview

XlsIO can be used to generate a new XLS document from scratch, extract data from an existing spreadsheet document or even edit an existing spreadsheet.

Spreadsheet Generation	Edit Spreadsheet
Extract Data From Spreadsheet

Excel 2007 Support

Essential XlsIO is one of the first products to natively support Excel 2007 Xlsx file format. 100% support for all Excel object types is not yet available, but several commonly used elements are already supported.

XLSX Support

Cell Styles Support

Formatting

Numerous formatting options are available for customizing the look and feel of the cells in the worksheet.

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

Document Settings

Essential XlsIO can work with spreadsheets that are stored as streams and can also save to a stream.

Streams Support

Document Properties

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