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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Overview

The WPF Spreadsheet control is an Excel-inspired control that allows you to create, edit, view, and format Microsoft Excel files without having Excel installed. It provides an integrated ribbon to cover any possible business scenario, maximizing its ease of use. It ships with a built-in calculation engine with support for more than 400 of the most widely used formulas. It is built on Essential XlsIO, which features a full-fledged object model similar to the Microsoft Office Automation libraries.


Compatible with Excel versions 97 to 2016

The Spreadsheet control for WPF is an Excel-inspired control which display and edit files based on all popular Excel file formats, including XLS and XLSX. You can even open a file in one format and save it to another format.

wpf spreadsheet control


Ease of use with interactive UI

  • The spreadsheet ribbon provides a familiar, Excel-like user interface to help end users work with Excel files.
  • The ribbon can be easily customized to manipulate Excel workbooks based on application requirements.
  • You can also create your own ribbon or toolbar to manipulate Excel workbooks using the predefined commands of the control.

excel like spreadsheet ribbon


High performance

wpf excel viewer

Instant loading

Load and manipulate Excel workbooks with a large amount of data and any number of worksheets in less time with minimal memory consumption.

spreadsheet smooth scrolling

Smooth scrolling

The spreadsheet control provides a smooth scrolling experience even with many cells in a view.

excel calculation in spreadsheet

Formula calculation

The spreadsheet control has a fast and efficient calculation engine with more than 400 Excel functions.


Data editing

excel like edit in spreadsheet

Data editing

Data editing comes with the ability to add, edit, and remove formulas in a cell. Users can also select the range reference directly using the mouse or keyboard while entering formulas, just like in Excel.

data validation for wpf spreadsheet

Data validation

Validate the edited values based on the data validation rules defined for a cell or range of cells. Data validations can be applied with operators, alert messages, custom formulas, and drop-down lists.

undo and redo operations for wpf spreadsheet control

Undo and redo

Undo and redo changes made in an Excel workbook. There is no limit to the number of undo and redo operations you can perform.

clipboard operations wpf spreadsheet control

Clipboard operations

Clipboard operations with Excel-like paste options enable users to paste values or formulas with or without formatting.

fill series like excel

Drag-fill

Drag-fill allows users to easily fill or copy a series or pattern of values and formats into neighboring cells in any direction.

hyperlinks and bookmarks for wpf spreadsheet

There’s built-in support for hyperlinks and bookmarks. Navigation through bookmarks to a specific cell or range of cells in a workbook is also supported as in Excel.


Formulas

A wide range of formulas is available with cross-sheet references, named ranges, table formulas, and array formula support.

excel like calculation for wpf spreadsheet

Built-in functions

The built-in calculation engine is preloaded with more than 400 Excel-compatible functions covering a broad range of business scenarios.

auto calculation in wpf excel viewer

Auto-calculation

Automatically recalculate values when a precedent cell is edited.

named ranges in wpf spreadsheet

Named ranges

Named ranges can be used in formulas as substitutes for cell references. The built-in name manager allows you to add, edit, and delete names.


Styles and Data Formatting

font formatting options in spreadsheet

Font

Import and modify various font formatting options like font size, font family, font styles, font color, and fill color.

wpf excel viewer alignment and merging

Align and merge cells

Import and modify various alignments, merged cells, and wrap settings from Excel.

excel like number format in wpf spreadsheet

Number formats

Import and modify number formats such as currency, percentage, short date, long date, time, fraction, scientific, and custom number formats similar to Excel.

import default styles in wpf excel viewer

Table formats and built-in styles

Import table formats and predefined cell styles from Excel. You can also format a range as a table and define cell styles at runtime.


Conditional formatting

Conditional formatting helps you visually explore and analyze data, detect critical issues, and identify patterns and trends.

conditional styling for wpf excel viewer

Conditional styling

Format the appearance of cells based on their value or the values of any other cells.

data bars for wpf excel viewer

Data bars

Use data bars to easily spot larger and smaller numbers.

color scales for wpf excel viewer

Color scales

Use color scales to understand data distribution and variations.

icon sets for wpf spreadsheet control

Icon sets

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


Data shaping

auto filter and sorting for wpf spreadsheet control

Sort and filter

Analyze data with automatic filtering and sorting.

group or ungroup rows in wpf spreadsheet control

Outline (Group)

Import outlines and group or ungroup rows and columns at runtime.


Chart and sparklines

import charts from excel to wpf spreadsheet

Charts

Import charts from Excel that can be defined at runtime. This helps visually enhance the represented data.

import sparklines from Excel to wpf spreadsheet

Sparklines

Import sparklines from excel to visually represent data in a row.


Interactive features

touch optimization for wpf spreadsheet control

Touch optimized

The spreadsheet control is touch-optimized for all user interactions, similar to Excel.

excel like selection for wpf spreadsheet

Excel-like selection

Select a range of cells, rows, columns, and tables. The spreadsheet control also supports all keyboard interactions with cell selections.

excel like cell comments for wpf spreadsheet

Cell comments

Import, add, edit, and delete cell comments.

zooming in wpf excel viewer

Zooming

Zoom in and out of worksheet contents. Plus, the zoom level can be imported and exported to and from Excel.

context menu in wpf excel viewer

Context menu

There’s built-in support for cell and tab context menus. Custom context menu items can also be added.

search and replace data in wpf excel viewer

Find and replace

Search the data in a workbook and replace it efficiently with advanced search options. Also select all cells with formulas, conditional formatting, constants, and data validation.


Data management

Import and export data from various sources with the help of XlsIO as an intermediary.

wpf excel viewer import and export


Worksheet management

  • Row height and column width: Import row heights and column widths from Excel. Also fit rows and columns based on their content.
  • Insert and delete: Insert and delete rows and columns in a single worksheet, or multiple worksheets in a workbook.
  • Hide and unhide: Hide and unhide rows and columns in a single worksheet, or across worksheets in a workbook.
  • Gridlines: Customize the visibility and color of gridlines.
  • Headings: Control the visibility of row and column headers in a worksheet.

manage work sheets in wpf excel viewer


Protection

  • Protect worksheets with or without a password, and restrict user actions like row and column insertion, deletion, resizing, and more.
  • Protect the structure of a workbook.
  • Encrypt workbooks with a password to prevent users from opening them.

protect worksheet in wpf spreadsheet


Conversion and printing

  • Convert Excel workbooks to other formats like CSV, PDF, HTML, and convert worksheets to an image.
  • Print the Excel workbook using the PDF viewer.

file format conversion and printing for spreadsheet


Localization

Localize all static text in the ribbon and built-in dialogs to any desired language.

wpf spreadsheet localization


90+ WPF 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