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. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Trusted by the world’s leading companies

Syncfusion Trusted Companies

Overview

UWP Excel framework is a high-performance and feature-rich to work with Microsoft Excel. This framework has Excel creation and editing library that allows you to create, read, and edit Microsoft Excel files in any .NET application. It offers Excel-inspired Spreadsheet UI controls to create, edit, and format Excel documents. Its powerful conversion APIs make it easy to convert Excel files to HTML, image, and more.

UWP Excel Framework Modules


Why Syncfusion?

No server deployment fees

There are no distribution fees, per-server licensing fees, or royalties, which makes Excel Library very cost-effective.

Blazing-fast performance

It is optimized for usage in a server environment where, speed and low memory usage is critical.

Powerful and comprehensive API

All the elements in a typical Excel document such as text, formatting, images, shapes, and tables are accessible through a comprehensive set of APIs.

Proven Excel library

Over more than 15 years, Syncfusion’s Excel Library (Essential XlsIO) has become a mature and proven product.

Fully documented

The Syncfusion’s Excel Library comes with extensive documentation, knowledge base, and samples.

Cross-platform

Use a single API across all platforms.


Excel - creating and editing APIs

Syncfusion's Excel Library (Essential XlsIO) is a high-performance UWP Excel library that allows users to create, read, edit, and protect Excel documents in UWP applications without Microsoft Office or interop dependencies.

Import and Export

Import and export

Import data from various data sources and collection objects. Also, export data to data tables, collection objects, and nested classes.

Excel Charts

Excel charting

Excel Library supports 80+ charts to visualize data. Similarly, sparklines are supported to visualize data within a cell.

Excel Formulas

Formulas

More than 400+ Excel functions are supported to evaluate formula cells. Add-in functions, external formulas, and an array of formulas are also supported.

Template Markers

Template markers

Import data to Excel worksheets like Mail merge in a Word document. Customized data importing is also supported.

Excel Formatting

Formatting

Use various cell and text formatting options along with advanced conditional formatting features to modify the appearance of the data.

Excel Data Processing

Data processing

Perform various kinds of data processing such as data validation, sorting, and filtering.

Pivot Tables

Pivot tables

Pivot tables and pivot charts are widely used due to their ease-of-use in summarizing data. Syncfusion’s Excel Library allows you to create and edit them with a few lines of code.

Excel Protection

Protection

Encrypt or decrypt password-protected Excel files. Also, protect the editing of workbooks, worksheets, and cells.

Excel Shapes

Shapes

Create and edit various form controls, autoshapes, and comments.


For more information, check out UWP Excel Library features.


Spreadsheet viewer and editor

The Spreadsheet control provides a Microsoft Excel-like control with major features of Microsoft Excel,
including editing, formulas, charting, importing, and exporting are supported.

High Performance

High performance

Open and save large Excel files in less time with minimal memory consumption. Experience smooth scrolling even with many cells in a view.

Open and Save

Open and save

Import and edit existing Excel files in the Spreadsheet control. Spreadsheets can be exported to XLS, XLSX, CSV, and PDF file formats.

Charts

Charts

Spreadsheet supports charts and sparklines. Visualize data easily.

Formulas

Formulas

More than 400 Excel-compatible functions are supported, such as cross-sheet references, named ranges, table formulas, and formulas.

Formatting

Formatting

The Spreadsheet control provides a variety of text and number formatting options along with conditional formatting to improve the appearance and effectiveness of spreadsheet.

Data virtualization

Data Virtualization

The Spreadsheet control supports on-demand data loading when bound to data sources. It improves initial loading time by requesting only the visible data from the data source.


For more information, check out our UWP Spreadsheet Control features.


Conversions

Excel to PDF conversion in UWP

Excel to PDF

Convert an Excel workbook or worksheet to PDF format. Use various customization options, like embedding fonts, ignoring empty pages or worksheets, showing or hiding headers, and footers.

Worksheet to Image conversion in UWP

Worksheet to image

Worksheets can be converted to BMP, JPEG, PNG and other image formats, with content such as data, formatting, charts, tables, and shapes.

Excel to CSV conversion in UWP

Excel to CSV/TSV

Convert Spreadsheet data to CSV and TSV formats to generate, lightweight reports.

Excel to HTML conversion in UWP

Excel to HTML

Dynamically render an Excel workbook or worksheet as an HTML file.

Excel to ODS conversion in UWP

Excel to ODS

Save Excel files in ODS formats to use in applications like OpenOffice and Google Sheets.

Excel to SpreadsheetML conversion in UWP

Excel to SpreadsheetML

SpreadsheetML is easy to work with and designed to be human readable and editable. Convert Excel files to SpreadsheetML using Syncfusion’s Excel Library.

Excel to JSON conversion in UWP.

Excel to JSON

Convert an Excel workbook or worksheet to JSON file in schema and non-schema formats.


UWP Excel Code Example

Easily get started with the UWP Excel Framework using a few simple lines of C# code example as demonstrated below. Also explore our UWP Excel Library Example that shows you how to render and configure the UWP Excel.

//Create an instance of ExcelEngine
ExcelEngine excelEngine = new ExcelEngine();

IApplication application = excelEngine.Excel;

//Instantiates the File Picker. 
FileOpenPicker openPicker = new FileOpenPicker();
openPicker.SuggestedStartLocation = PickerLocationId.Desktop;
openPicker.FileTypeFilter.Add(".xlsx");
openPicker.FileTypeFilter.Add(".xls");
StorageFile openFile = await openPicker.PickSingleFileAsync();

//Opens the workbook. 
IWorkbook workbook = await application.Workbooks.OpenAsync(openFile);

//Access first worksheet from the workbook.
IWorksheet worksheet = workbook.Worksheets[0];

//Set Text in cell A3.
worksheet.Range["A3"].Text ="Hello World";

//Sets workbook version.
workbook.Version = ExcelVersion.Excel2013;

//Initializes FileSavePicker.
FileSavePicker savePicker = new FileSavePicker();
savePicker.SuggestedStartLocation = PickerLocationId.Desktop;
savePicker.SuggestedFileName = "CreateSpreadsheet";
savePicker.FileTypeChoices.Add("Excel Files", new List<string>() { ".xlsx" });

//Creates a storage file from FileSavePicker.
StorageFile storageFile = await savePicker.PickSaveFileAsync();

//Saves changes to the specified storage file.
await workbook.SaveAsAsync(storageFile);

workbook.Close();
excelEngine.Dispose();




Frequently Asked Questions

The Syncfusion UWP Excel Framework provides the following features:

  • Create, read, edit, and view Excel files with just a few lines of code.
  • Utilize top features: charts, formulas, tables, pivot tables, data validation, data import and export, conditional formatting, shapes, and security.
  • Import data into a customized format using Template Markers.
  • Perform quick evaluation with 400+ functions.
  • Convert Excel files into ODS, HTML, and images.
  • One of the best UWP Excel libraries on the market, offering a rich set of APIs to interact with the software.
  • Extensive demos, documentation, and videos to learn quickly and get started with Syncfusion XlsIO.

No, this is a commercial product and requires a paid license. However, a free community license is also available for companies and individuals whose organizations have less than $1 million USD in annual gross revenue, 5 or fewer developers, and 10 or fewer total employees.

A good place to start would be our comprehensive getting started documentation.

Apart from UWP, the Syncfusion Excel framework supports platforms for web (Blazor, Flutter, ASP.NET Core, ASP.NET MVC, and ASP.NET Web Forms), mobile (.NET MAUI, Flutter, and Xamarin), and desktop (Windows Forms, WPF, WinUI, .NET MAUI, Flutter, and Xamarin).

You can find our Excel Framework demo here.

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

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.

Scroll up icon
Live Chat Icon For mobile