Your account has not been activated. Click here to send an activation email to your email address.
Unfortunately, activation email could not send to your email. Please try again.

Conceptual Overview Diagram

General information

Blazing fast performance

Optimized for a server environment where speed and low memory usage are critical. This works much faster and consumes lesser memory than office automation libraries.

No server deployment fees

There are no distribution fees, per-server licensing fees, or royalties, making XlsIO very cost-effective.

Easy migration from Office Automation

Easy to migrate existing office automation code to XlsIO since the APIs are very similar.

Compatible with Excel versions 97 to 2016

Reads and writes all popular Excel file formats including XLS and XLSX. A file can be opened in one format and saved in another format.

Powerful and comprehensive API

The comprehensive API makes it possible to create richly formatted Excel files with elements like text, numbers, formatting, images, charts, and pivot tables. It is also possible to extract any desired piece of information from an existing workbook.

Start Reports with Excel and finish with XlsIO

Reports can be designed using Microsoft Excel, and XlsIO can be used to dynamically populate them with data. Final report can then be saved to an Excel file or exported to other supported formats, like PDF.

Data

Import Data

Easily imports data from all the common data sources, like arrays, data tables, and CLR objects, into an Excel worksheet.

Export data

Data in an existing worksheet can also be exported to data tables and CLR objects.

Sorting

Data sorting can be performed based on cell value, cell color, and font color using multiple sorting algorithms.

Filters

XlsIO supports various filter options like Top, Top10, Percent, etc., with different filter types such as custom, combination, dynamic, color, icon and advanced filters.

Data validation

Cell data validations can be applied with operators, alert messages, custom formulas, and drop-down lists.

Efficient calculations

Built-in functions

The built-in calculation engine quickly evaluates formula cell values during runtime. This supports over 400 Excel functions.

Named ranges

Named ranges can be used in formulas as substitutes for cell references. The built-in name manager allows adding, editing, and deleting names.

Template markers

Data grouping

Imports hierarchical data from multiple tables.

Import images

Imports images like JPEG, PNG, BMP, TIFF, and GIF in customized formats.

Dynamic formatting

Applies conditional formats to the template marker range with data bars, color scales and icon sets.

Excel charting

80+ Chart types

Creates and edits all types of Excel charts including Excel 2016 charts.

Custom charts

Charts with different types of series can be created.

Sparkline

Creates a tiny chart in a worksheet cell that provides visual representation of the data.

Charts to image

Charts can also be converted to images using just a few lines of code.

Conditional formatting

Data bars

Uses data bars to easily spot larger and smaller numbers.

Color scales

Charts with different type of series can be created.

Icon sets

Icon sets distinguish data in three or five categories based on the threshold value.

Excel formatting

Formatting options

XlsIO supports various formatting options like number formats, alignments, font settings, borders, colors, rich-text, etc., that makes data more readable.

Styles

Creates custom styles or applies built-in styles to cell ranges. Built-in styles can also be applied for tables.

Row column manipulation

XlsIO performs various cell level operations like resizing rows and columns, hiding and showing rows and columns, adding or deleting rows and columns, grouping and ungrouping, subtotaling, etc.

Page setup

Enables page settings like orientation, paper size, scaling, margins, print area, print titles, header and footer, etc.

Pivot

Pivot Tables

Creates and edits pivot tables and pivot charts with just a few lines of code. General filter options, such as page filters, row filters, and column filters, with various pivot table visibility settings, and custom sorting are also supported.

Conversion and printing

Convert Excel

Converts Excel documents to PDF, ODS, HTML, and images. Excel charts can also be converted to images.

Prints Excel document from code with various print settings without dependency of Microsoft Excel or Adobe Reader.

Security

Encryption and decryption

Reads and writes password-protected Excel documents with various algorithms like SHA 128, SHA256, SHA512.

Protection

Enables and disables workbook and worksheet protections along with locking cells.

Shapes

Form Controls

Creates and edits text box, option button, check box, and combo box controls to enable user-friendly worksheets.

AutoShapes

Creates and edits 150+ auto-shapes in Excel.

Comments

Creates and edits comment shapes with rich-text format and various fill options including gradient styles.

Feature Matrix

Workbook Features XLSX XLS
Create an Excel workbook from scratch or modify an existing workbook.
Open an existing Excel workbook from file system or stream.
Save Excel workbook to a local file, stream, or stream it to the client browser.
Read worksheets on demand when Excel file contains multiple worksheets.
Hide and unhide worksheets.
Add or extract custom XML documents.
Add or modify document properties.
Import and Export XLSX XLS
Import data from data table, data column, data view, arrays, and CLR objects to worksheet.
Import data into a pre formatted template using template markers.
Importing large amounts of data with minimal memory consumption can be achieved using the import on save option.
Export data from worksheet to data table.
Export data from worksheet to CLR objects.
Imports data from various external sources like Microsoft Access, SQL Server and Excel, which maintain the connection to refresh data dynamically.
Formulas XLSX XLS
Read and write Excel formulas.
Add or modify named ranges in workbook and worksheet levels.
Perform calculation for a range of cells using named ranges.
Apply or modify Excel formula auditing settings.
Enable automatic and manual calculation options.
Trace the relationships between the cells and formulas through dependent and precedent ranges.
Charts XLSX XLS
Creation and manipulation of Excel 2-D charts.
Creation and manipulation of Excel 3-D charts.
Creation and manipulation of custom charts.
Creation and manipulation of sparklines. NA
Creation and manipulation of Excel 2016 charts. NA
Pivot Tables
Creation and manipulation of pivot tables (while saving as XLS format, the pivot table is preserved as-is from the input XLS file).
Apply various pivot table settings like page filter, row filter, and column filter (while saving as XLS format, pivot table is preserved as-is from the input XLS file).
Supports pivot table settings such as visibility of field list, collapse button, field caption and field option, header captions, etc.
Worksheet Features XLSX XLS
Formatting
Creation and manipulation of conditional formatting (supports icon sets, data bars, color scales, and specific date in XLSX).
Auto fit or resize rows and columns.
Apply or modify number formats.
Apply or modify fill settings.
Apply or modify font settings.
Apply or modify cell border settings.
Apply or modify all the cell text alignments.
Excel 2007 themes.
Copy/Paste
Add or copy worksheets within or across workbooks.
Copy a range to another range across worksheets.
Copy a range with different copy options.
Move a range to another range across worksheets.
Data
Creation and manipulation of data validation.
Apply or modify AutoFilters to filter worksheet data.
Apply or modify color or icon filters to filter worksheet data.
Apply or modify data sorting.
Find and replace data.
Row/Column Manipulation
Apply and modify view settings to freeze, unfreeze, and split panes.
Hide and unhide rows and columns.
Merge and unmerge cells.
Insert
Insertion and deletion of images in worksheets.
Apply or modify background image in a worksheet.
Add, remove, and modify hyperlinks.
Group or ungroup rows and columns.
Add or modify subtotals of grouped data.
Addition and deletion of OLE objects.
Security
Open and save encrypted and decrypted documents.
Protect and unprotect workbook.
Protect and unprotect worksheets.
Lock and unlock cells for write protection.
Page Setup
Set and get header and footer settings.
Apply and modify horizontal and vertical page breaks.
Apply and modify custom page breaks.
Apply various page setup options like paper size, orientation, scaling, margins, etc.
Apply print settings.
Print workbook with custom page settings.
Shapes
Creation and manipulation of autoshapes.
Creation and manipulation of check boxes.
Creation and manipulation of combo boxes.
Creation and manipulation of comments.
Creation and manipulation of text boxes.
Miscellaneous
Preserve Macros
Conversion XLSX XLS
Converts Excel document to PDF.
Converts an entire Excel worksheet into a single image.
Converts specific range of an Excel worksheet into a single image.
Converts Excel charts to images (.NET framework 4.0 and above).
Converts Excel document to ODS (Open Document Spreadsheet).

PRICING

buy-now-img

File Formats

$ 995

One developer per license

Developer Platform

Essential Studio

$ 1,995

One developer per license

best-img

Unlimited Global License

Cover everyone in your organization for one low annual fee

CONTACT US
DEVELOPER PLATFORM
800 web, desktop, and mobile controls
File Formats (Word, Excel, PowerPoint, and PDF)
DATA PLATFORM
Dashboard Platform
Big Data Platform
Report Platform
Data Integration Platform
SUPPORT
Dedicated Account Representative
Quarterly product releases
Support within 24 hours on all business days
LICENSING
Licensing Mangement Portal
Commercial Use
Max Developer Count
1 per license
1 per license
Unlimited
Coverage Period
1 year
1 year
1 year


RESOURCES

CASE STUDY

Syncfusion’s file format components helped me create the reports I needed, fast. – J. Pereira, Software Developer.

The libraries have been built from scratch and refined for more than a decade to provide blazing-fast performance, comprehensive API, and compatibility across the latest and older versions of these files.

CONTINUE READING View all Customer Stories

VIDEOS

Syncfusion File Format Libraries - Manipulate Excel, Word, PowerPoint, and PDF files

Read and write Excel, Word, PDF, and PowerPoint files. Also includes integrated visualization capabilities. Advanced features include support for pivot tables, pivot charts, mail-merge, and extensive formatting.

E-BOOK

Succinctly Series: Statistics Using Excel Succinctly

Succinctly Series: Statistics Using Excel Succinctly


- by Charles Zaiontz
CONTINUE READING View all E-books

A well known industry partner

Working with the industry’s best and brightest minds to streamline reporting

industry-partner
  • "Syncfusion has all of the required controls, reporting and dashboarding tools across multiple platforms that allow us to leverage our existing skills with a simple and value-for-money licensing model."
    Jono Walker, Walkerscott
  • "An excellent toolset and a great support team. I’ve been using Syncfusion’s products for a couple of years, and they save me a lot of time on development."
    Oswaldo Diaz, Product Manager, Hipermetrics.com

Awards

Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion is proud to hold the following industry awards.

syncfusion-awards

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.