Essential Studio for
ASP.NET
Enterprise class toolkit with 60+ unique controls.
Banner Image
Banner Image
Banner Image
$995
Special Introductory pricing, includes one year of free support and updates.
XlsIO
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 reports in Windows, web, WPF, MVC, and Silverlight applications.
Overview
Process Excel Files
Design and Generate Excel Reports
Export Options
Editing Excel Files
Overview
Compatible with Microsoft Excel Versions 97 to 2010
Essential XlsIO can create and consume files based on all Excel file format variants. Native file format for Excel versions 97–2003SpreadsheetML—Excel 2003 XML file formatXLSX, XLSM—Open XML formats used in Excel 2007 and 2010. You can even open a file in one format and save it back in another format.
Native .NET Component
Essential XlsIO is a native .NET library written in C# which allows you to use it in Windows desktop as well as Web apps, including a native version of Silverlight. This also provides a much better user experience and performance compared to other solutions available in the market that are wrappers over COM components, libraries ported from Java, Delphi, etc.
Blazing Fast Performance
Essential XlsIO has been optimized for usage on servers where speed and memory usage are critical. It can easily handle multiple requests for report generation in scenarios such as Web sites serving reports to hundreds of simultaneous users. Essential XlsIO is also highly optimized to generate Excel files with a large amount of data. It is optimized for both low memory usage and speed. It works more than 100 times faster than MS Excel automation and consumes much less memory compared to that of MS Excel. The Silverlight version of the library is a native Silverlight client-side library that off-loads all the processing to the client machine, making it an infinitely scalable reporting solution for your Web apps.
Easily Migrate from Office Automation
If you have code that's already written using Office automation, it is very easy to migrate that code to XlsIO since the APIs are very similar. However the similarity ends there; XlsIO is more than 100 times faster than Office automation.
No Server Deployment Fees
There are no distribution fees, per-server licensing fees, or royalties, making XlsIO very cost-effective.
Proven, Reliable Solution
Essential XlsIO has thousands of customers who generate millions of Excel reports daily in demanding production environments.
Process Excel Files
Start Reports with Excel and Finish with XlsIO
Syncfusion Essential XlsIO lets you add Microsoft Excel reporting capabilities to your .NET applications within minutes. Let designers visually design reports using Microsoft Excel, and then use Essential XlsIO to populate it with dynamic data during run time, to generate an invoice for example. You can save the final report to a local file, stream, stream it to the client browser, or even export to other formats we support.
feature image
feature image
This approach also allows you to add some XlsIO unsupported features like macros into your Excel files through MS Excel rather than through XlsIO.
Consume Data Stored in Excel Workbooks
When you read an existing Excel document using XlsIO, the entire document is parsed and available for manipulation through its object model. This makes consuming data stored in Excel documents as simple as loading a workbook and accessing the data through XlsIO’s intuitive object model. XlsIO also provides APIs that makes working with ADO.NET data sources very easy. It only takes one line of code to import an ADO.NET DataTable into a worksheet or vice versa. There are APIs for working with other data sources like DataView, DataColumn, Arrays etc.
feature image
Merge Excel Workbooks
Essential XlsIO has support for copying a worksheet from one workbook to another. This feature can be used to merge several workbooks together.
Process Formulas
XlsIO lets you read/write the formula in a cell and the computed value. But also, combine with our Essential Calculate to convert your Excel file into an in-memory spreadsheet where you can edit some cell values and retrieve the computed formulas from other cells. Essential Calculate supports nested formulas and supports nearly 150+ functions that cover all common Excel functions.
Find Replace Support
Essential XlsIO provides rich APIs to carry out the search and replace operation within workbooks. You can find a number or text or date with the specified format, extract it, and replace it with a given value.
feature image
Design and Generate Excel Reports
Generate Excel documents dynamically
While starting from an Excel workbook as a template is convenient, XlsIO extends you the ability to create a whole new Excel workbook from scratch programatically. APIs allow you to insert all common Excel elements and features:Text box insertion and formatting.Text styles (alignment, bold, italic, underline, font name, and font color), including rotated text.Global, row, and column styles for reuse in different cells as well as the ability to overwrite such styles in specific cells.Image insertion with support for inserting scalar as well as vector images at specific locations.Number formats.Conditional formats.Formulas.Charts.Data validation.Auto filters.Print settings.Pivot table and pivot charts.Cell borders and cell background patterns.
feature image
feature image
Conditional Formatting
XlsIO lets you define the rules in code and also specify the formatting options for the cells when these conditions are met. Color scales: Conditionally format the text and background color of the cells.Data bars: Show data bars in cells whose widths vary based on the cell value.Icon sets: Show icons in cells based on the cell value.
feature image
Data Validation
Essential XlsIO allows you to add data validation rules to a cell. Data validation is a feature in MS Excel which makes it possible to dynamically validate data entered in a cell.
feature image
Auto Filters
Auto filters can be used to filter out records based on a specific criteria. Essential XlsIO has APIs to insert an auto filter into a worksheet, specify the criteria, and specify the range that needs to be filtered.
feature image
Layout Options
Freeze Columns and Rows to the left and on top using the XlsIO APIs.
feature image
Group and ungroup rows and columns to easily expand/collapse them.
feature image
Specify custom Row Height and Column Width for rows and columns in a worksheet. You can also show/hide rows and columns as well as add/remove rows and columns.
feature image
Simple APIs allow you to Auto Fit specific columns and rows, making them resize automatically to fit it's contents.
feature image
Essential XlsIO lets you specify the exact horizontal and vertical Page Breaks while printing.
feature image
You can also programatically insert Page Header and Page Footer for printed sheets.
feature image
Essential XlsIO has APIs to specify the Page Orientation(landscape or portrait) and other page setup properties while printing. You can also specify Page Margins for printed sheets.
feature image
Cell Comments
Essential XlsIO has rich set of APIs for reading, inserting, and deleting both regular and rich text comments for cells in a workbook. The APIs allow you to paint the background of the comment window with different styles such as gradient, solid color, texture, picture, and pattern.
feature image
Charts Support
Add Embedded Charts to an Excel file with support for different chart types, 3D effects, custom chart area look and feel, custom data points look and feel, custom axis formats, legend customization and numerous other options. Finally specify the range of cells from which to populate the data for the chart.
feature image
There is also support for creating Chart Worksheets where a single chart is rendered in the whole worksheet. Several formatting options are available to customize the look and feel of such charts as well.
feature image
Pivot Tables
A comprehensive set of APIs is included to create and customize the look and feel and behavior of pivot tables within Excel. Bind the pivot table to data, define fields based on which you want to support pivoting, and even specify the default fields the pivot should load with.
feature image
Advanced Security Features
By using Password Encryption in Essential XlsIO, you can secure the data in your reports and make it impossible for anyone to view the workbook without the password. There are also several other options available to restrict specific user actions like inserting, formatting, and deleting rows.
Essential XlsIO lets you add Workbook Protection to protect a workbook's structure or windows. By protecting the structure, you can prevent the user from moving the workbooks around, inserting new ones, etc. By protecting the windows in the workbook, you can control the size of the workbook, etc.
Essential XlsIO has support for adding Worksheet Protection. This prevents the end user from editing the contents of the worksheet while optionally letting the end users perform some operations on the worksheet like format cells, etc.
feature image
While opening a workbook through XlsIO you will also have the ability to decrypt or unprotect a workbook/worksheet using the appropriate passwords.
Document Properties
The built-in document properties such as Application Name, Document Title, Category, Keywords, Company, etc. can be set for the documents using Essential XlsIO. It is also possible to set custom document properties as well.
feature image
Most Advanced Component in the Market
Essential XlsIO was one of the first Excel manipulation libraries available for the .NET platform when it was released in 2003. Over the years the constant feedback from our customers has helped us transform it into the most advanced Excel reporting library available in the market today. Besides the features listed above, more features available include support for named ranges, end-user report customization, Unicode, right-to-left tex,t and adding Excel and custom add-ins.
Export Options
Generate PDFs, Word Docs, and HTML
Combine with Essential PDF to generate PDFs on the fly from Excel worksheets. You can even choose to scale the export to fit in rows and/or columns in one page. Again, no Acrobat or Excel needs to be installed for this conversion.
feature image
Combine with Essential DocIO to generate Word documents from Excel worksheets. You can easily create tables in a Word document by exporting a range of cell values, including their formatting, from the Excel worksheet into that Word document. Again, no need for Excel or Word to be installed.
You can also export the Excel worksheets to HTML for presentation in Web sites, e-mails, etc. Or you can even export worksheets to plain CSVs.
Editing Excel Files
Editing with Spreadsheet control
Essential Spreadsheet allows you to import contents from an Excel file (.xls or .xlsx), edit, and save them to the Excel file. All common features you expect from Excel are supported including formula editing and automatic computation, conditional formatting, rich text formatting, etc.
feature image
::adCenter::