Create standards compliant Excel (Legacy, Office 2007 and Office 2010) 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. Essential XlsIO enables users to create document based report in Windows, Web, WPF, MVC and Silverlight applications.

Overview

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

• Spreadsheet Generation
• Edit Spreadsheet
• Extract Data From Spreadsheet

Excel 2007 and Excel 2010 Support

Essential XlsIO is one of the first products to natively support the XLSX file format. Supported features include creating spreadsheets in Excel 2007 and Excel 2010; the advanced features of Excel 2007 and Excel 2010 are also supported, such as conditional formatting representations, pivot tables, and rich 2007 built-in styles.

• 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
• OLE Object

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

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

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

Export

This section deals with the conversion of Excel documents into various file formats.

• Worksheet to Image
• Excel to HTML
• Excel to PDF

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

Silverlight Support

To learn more about the supported features in Silverlight, please visit the below documentation link.

• Supported Elements in Silverlight