We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Excel Library

Overview

High-Performance Excel library for creating, reading, and editing Excel files in UWP applications.

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 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.

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.

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.

70+ UWP CONTROLS

Transform your applications today by downloading our free evaluation versionDownload Free Trial

Scroll up icon

Warning Icon 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.Close Icon