Screenshot Preview

Syncfusion Essential XlsIO

by Syncfusion - Product Type: Component / ASP.NET WebForms / ASP.NET MVC / .NET WinForms / .NET WPF / Silverlight / 100% Managed Code / Windows Runtime Controls

This product is no longer sold individually, but is available within Syncfusion Essential Studio Enterprise Edition and one of Syncfusion’s 9 platform-dedicated suites.

Easily read, write, and modify Microsoft Excel (xls, xlsx) files, even on systems that do not have Microsoft Excel installed. Syncfusion Essential XlsIO is compatible with both the Biff 8 format xls files and the Office 2007/2010 xlsx format files. Essential XlsIO’s extensive feature set includes support for cell formatting, creating and applying custom styles, applying conditional formatting, formula processing, charts, security settings, etc. This .NET library features a full-fledged object model similar to the Microsoft Office COM libraries. Syncfusion Essential XlsIO does not use COM interop and is available with full 100% C# source code. Included with every XlsIO license is a one-year subscription for unlimited technical support and updates.

Average Review:   based on 18 reviews.

Please note: Syncfusion Essential XlsIO includes Silverlight, ASP.NET, ASP.NET MVC, Windows Forms and WPF components.

What's new in Essential XlsIO 2012 Vol 4?

  • XlsIO Library for WinRT - Essential XlsIO is available for WinRT. This powerful class library enables Windows Store applications to read and write Microsoft Excel files. It exposes a comprehensive object model that covers most of the functionality Excel itself offers, making it possible to create reports that contain advanced elements like charts and pivot tables. All versions of Excel 97-2013 are supported.

What's new in Essential XlsIO 2012 Vol 2?

  • Pivot Engine Integration - Essential XlsIO now provides support for setting up a pivot table. Using this feature, pivot table content can be accessed dynamically. Report filters can also be applied to the pivot table.

What’s new in Syncfusion Essential XlsIO 2011 Vol 4?

  • Binding Business Objects to Template Markers - Support has been added for binding business objects to template markers by binding a list of custom class objects to template markers. It also supports header names, images, and Enumeration-type business objects.

Syncfusion Essential XlsIO 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.

Syncfusion Essential XlsIO  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

Syncfusion Essential XlsIO 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

Syncfusion Essential XlsIO 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.

Syncfusion Essential XlsIO Exporting

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

Syncfusion Essential XlsIO Spreadsheet-Property Settings
Essential XlsIO has support for reading and writing spreadsheet properties.

Syncfusion Essential XlsIO Excel Support
Essential XlsIO 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.

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

Syncfusion Essential XlsIO 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

Syncfusion Essential XlsIO 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

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

Syncfusion Essential XlsIO 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.

Product Search

Enter search words:

The Software Superstore for IT Professionals

As Official Distributors, ComponentSource offers convenient, one-stop shopping from 250+ Software Publishers specializing in Application Development & Operations.

More Info | About Us

Screenshot Gallery

Click for full screen preview

Screenshot of Syncfusion Essential XlsIO - .NET Component - 2012 Screenshot of Syncfusion Essential XlsIO - .NET Component - 2012 Screenshot of Syncfusion Essential XlsIO - .NET Component - 2012 Screenshot of Syncfusion Essential XlsIO - .NET Component - 2012