::adCenter::
Sales: +1 919.481.1974
Bookmark and Share

Essential XlsIO

Download a fully functional trial of Essential Studio and test it out.
Run live samples hosted on our server.
View XlsIO Silverlight samples (requires Silverlight 4).

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.

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.

Formatting

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

Calculations

Essential XlsIO has advanced support for working with formulas within cells.

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.

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.

Security

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

Export

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

Document Settings

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

Spreadsheet-Property Settings

Essential XlsIO has support for reading and writing spreadsheet properties.

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.

Silverlight Support

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

Pivot Table

Pivot Table

Cell Styles

Cell Styles

Conditional Formatting

Conditional Formatting

Encryption

Encryption

Form Controls

Form Controls

Template Marker

Template Marker

Charts

Charts

Worksheet to Image

Worksheet to Image

Sparklines

Sparklines

Import - Export DataTable

Import - Export DataTable

Formulas

Formulas

Data Validation

Data Validation

Interactive Features

Interactive Features

Document Settings

Document Settings

Worksheet Manipulation

Worksheet Manipulation

Row Column Manipulation

Row Column Manipulation

Excel To Pdf

Excel To Pdf
Development Environments
  • Visual Studio 2010
  • Visual Studio Team System 2008
  • Visual Studio 2008 Professional Edition
  • Visual Studio 2008 Standard Edition
  • Visual Web Developer® 2008 Express Edition
  • Visual Studio 2005 Professional Edition
  • Visual Studio 2005 Standard Edition
  • Visual Web Developer® 2005 Express Edition
  • Silverlight 4.0
.NET Framework versions
  • .NET 4.0
  • .NET 3.5 SP1
  • .NET 2.0
Operating Systems
  • Windows Server 2008 (32 bit and 64 bit)
  • Windows 7 (32 bit and 64 bit)
  • Windows Vista (32 bit and 64 bit)
  • Windows XP
  • Windows 2003
(Free Trial - 385 MB)