Create standards compliant Excel (Legacy and Office 2007) reports from any .NET platform

Essential XlsIO is a .NET library that can read and write Microsoft Excel files. It features a full-fledged object model similar to the Microsoft Office Automation libraries. It can be used on systems that do not have Microsoft Excel installed, making it an excellent report engine for tabular data.

Overview

Essential XlsIO can be used to generate a new Excel document of .XLS,.XML[Spreadsheetml],.XLSX and .CSV format, extract data from an existing spreadsheet document or even edit an existing spreadsheet.

• Edit Spreadsheet
• Extract Data From Spreadsheet
• Spreadsheet Generation

Excel 2007 Support

Essential XlsIO is one of the first products to natively support Excel 2007 XLSX file format. Advanced features of Excel 2007 like Conditional formatting representations,pivot tables, rich 2007 built in styles are also supported.

• XLSX Support
• Cell Styles Support
• Advanced Conditional Formatting
• Tables Support
• Pivot Table

Formatting

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

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

Calculations

Essential XlsIO has advanced support for working with formulas within 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.

• AutoFilters
• Data Validation
• Find Replace Support
• Import Export Data Table
• Named Ranges
• Range Manipulation
• Form Controls

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
• Page Break
• Preserving Unsupported Elements
• Row-Height and Column-Width
• Worksheet to Image

Charts

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

• Chart Look and Feel
• Chart Types

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.

• Document Properties
• Streams Support

Spreadsheet-Property Settings

Essential XlsIO has support for reading and writing 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