Excel-inspired Spreadsheet for WPF

Open, edit, and save Excel and OpenXML files.

Provide the UI experience your end-users have come to expect from today's most popular office productivity suite and deliver Excel inspired functionality with minimal effort.

The DevExpress WPF Spreadsheet control displays Excel workbooks containing formulas, data sources, pivot tables, charts, and other advanced Excel capabilities with a great deal of precision. It supports nearly all Microsoft Excel document formats including:

  • XLS, XLSX, XLSM, XLSB, BIFF5
  • XLT, XLTX, XLTM
  • CSV
  • TXT

Free Trial

WPF Spreadsheet Control | DevExpress

Print. Export to PDF

Reporting made easy.

Turn the contents of your workbook or specific worksheets into a printed report or file with a simple method call or using the Print Dialog. Use built-in dialogs to customize page margins, document orientation, paper size, add headers/footer, incorporate page numbers, current date and file name to printed worksheets.

With the Print Titles option you can specify rows and columns that will be printed on each printed page. This can make your printed copy easier to read.

And of course, our WPF Spreadsheet can also convert workbooks to PDF and HTML.

Free Trial

Print, Export to PDF - WPF Spreadsheet Control | DevExpress

400+ Formulas & Functions

Excel compatible functions are built-in.

Over 400 built-in functions with array formula support allow you to create formulas and perform high-precision and multi-threaded calculations at incredibly fast speeds. You can use basic mathematical functions to aggregate data within a spreadsheet or create complex formulas with statistical, engineering, and financial functions for advanced data analysis.

Our WPF Spreadsheet includes RTD (Real-Time Data) function. The RTD function retrieves data in real time from programs that support COM automation. Financial apps use this function to pull market data from various financial service data providers (Yahoo! Finance, Google Finance, Bloomberg, etc.) into spreadsheets.

Spreadsheet API allows you to create your own functions. Custom functions are available for all spreadsheet calculations, and can be used in formulas.

Free Trial

Formulas and Functions - WPF Spreadsheet Control | DevExpress

Data Visualization at its Best

Charts, Pivot Tables, Sparklines

Summarize, analyze, explore, and present your worksheet data graphically. Embed an Excel-like pivot table engineered for multi-dimensional data analysis and cross-tab reporting. Add a chart to visualize information. Our WPF Spreadsheet control supports sparklines (Line, Column, Win/Loss) and a wide range of 2D/3D charts:

  • Column and Bar Charts
  • Line and Area Charts
  • Pie and Doughnut Charts
  • Scatter, Radar and Bubble Charts
  • Stock Charts

Free Trial

Data Visualization - WPF Spreadsheet Control | DevExpress

Conditional Formatting & Styles

Intuitively present workbook data to your users.

Our WPF Spreadsheet ships with Microsoft Excel-inspired Conditional Formatting support. This powerful feature allows you to highlight cells based on specified criteria without writing a single line of code. Cells can be highlighted with data bars, icons and predefined color scales.

End-users can easily apply a varity of predefined style conditions and make worksheets easier to understand. Integrated Ribbon UI allows end-users to add, change, or remove conditional formatting styles much like they do in Microsoft Excel.

And of course, you can use cell styles to apply predefined formats, and other manual formatting features to highlight important data.

Free Trial

Conditional Formatting - WPF Spreadsheet Control | DevExpress

Data Editing & Validation

Keep your data clear and accurate.

Our Spreadsheet control gives you the total control over cell editing.

  • Auto Fill
  • Formula Bar
  • Copy / Cut / Paste / Paste Special
  • Copy / Cut / Paste / Paste Specials
  • Redo / Undo
  • Highlight Invalid Values

You can use predefined in-place editors or embed your own (custom) data editors into worksheet cells.

Free Trial

Data Editing and Validation - WPF Spreadsheet Control | DevExpress

Shape & Search Data Instantly

A broad range of data shaping and filter options.

Unleash the power of information and intuitively present it to your end-users. Our WPF Spreadsheet ships with dozens of data shaping and search options, including:

  • Outlines (Group Data)
    Provide your end-users the ability to arrange related columns and rows into collapsible groups, as well as to create a quick summary. Outlines can either be created manually or automatically for an entire worksheet or just for a range of data.

  • Sort Spreadsheet Data
    Sort worksheet data against any number of columns. Treat cell values as text (to sort alphabetically, according to the current culture), numbers, or date-time values.
  • Filter Cell Values
    You can filter data in a range or table. Enable AutoFilter and filter by values or use built-in type-specific comparison operators such as 'greater than' and 'begins with' to show data you want and hide the rest.
  • Find / Replace
    You can search within a worksheet, specify whether the operation should be case-sensitive, and search using regular expressions.
Shape and Search Data Instantly - WPF Spreadsheet Control | DevExpress

Protect Your Work

Prevent unauthorized access.

Password encryption prevents unauthorized users from opening or modifying your workbooks. You can restrict changes to workbooks, worksheets, and specific ranges. In a protected workbook, users are not allowed to add, delete or rename worksheets.

Various sheets can have different protection levels. For instance, you can unlock a range for some users while other users may be prompted for a password.

You can configure which actions are available to users and which are restricted. Unavailable operations will be hidden from corresponding context menus and disabled in Ribbon UI.

Free Trial

Protection and Encryption - WPF Spreadsheet Control | DevExpress

Best in Class Tools

DevExpress is honored to have been voted best in class 20 times in this year's Visual Studio Magazine Reader's Choice Awards.

Experience the DevExpress difference and see why your peers consistently vote our products #1. With our Universal Subscription, you will build your best, see complex software with greater clarity, increase your productivity and create stunning applications for Windows, Web and your Mobile world.

x20
x18
x19
x19

Buy this product as part of the following subscription packages.

We are so confident in our products and services that we back them with a 60 day no questions asked money back guarantee. If within the first 60 days of ownership you are not satisfied with the capabilities of our tools, you can request a full refund of the amount you paid to DevExpress by writing to clientservices@devexpress.com or by calling +1 (818) 844-3383.

Best Value
WinForms Controls
WPF Controls
TreeView
Sunburst
ASP.NET Web Forms Controls
Printing & Exporting
ASP.NET MVC Extensions
Printing & Exporting
ASP.NET MVC Client-Side Controls
ASP.NET Core Controls
ASP.NET Core Office Controls
ASP.NET Bootstrap Controls
Themes and Skinning
JavaScript - jQuery, Angular, React, Vue
Blazor UI Components
Grid Layout
Stack Layout
UWP Controls
Reporting
WinForms Document Viewer
WinForms End-User Report Designer
ASP.NET Web Forms Document Viewer
ASP.NET Web Forms End-User Report Designer
ASP.NET MVC Document Viewer
ASP.NET MVC End-User Report Designer
ASP.NET Core Document Viewer
ASP.NET Core End-User Report Designer
Blazor Document Viewer
Blazor End-User Report Designer
WPF Document Viewer
WPF End-User Report Designer
Angular Document Viewer
Angular End-User Report Designer
XPO - ORM Library
Office File API (Basic)
.NET Standard 2.0+ Support (Windows, Linux, MacOS)
Office File API (Complete)
.NET Standard 2.0+ Support (Windows, Linux, MacOS)
Business Intelligence Dashboard
XAF - Cross-Platform .NET App UI
Role-based Access Control and User Authentication (.NET)
Xamarin.Forms UI Controls with Support
Native Mobile UI Controls
CodeRush with Support
C#, VB.NET, XAML
CodeRush Classic
VS 2015 Support
VS 2012, 2013 Support
C#, VB.NET, XAML
HTML, ASP.NET, CSS, Razor, JavaScript
Source Code *
WinForms Controls
ASP.NET Controls
WPF Controls
JavaScript - jQuery, Angular, React
Blazor UI Components
UWP Controls
XPO - ORM Library
Office File API
Data Visualization Dashboard
XAF - Cross-Platform .NET App UI
Technical Support
Priority Support

* DevExpress does not include/ship source code for certain products, including CodeRush, TestCafe Studio, and Report & Dashboard Server.

Additional Info

WPF Themes and App Skins

The DevExpress WPF Subscription ships with over 30 custom designed and highly polished themes for your next WPF application. You can use each of these themes easily, without modification or manipulate them using our free WPF Theme Designer application. Learn More

Touch Enabled User Experience

Deliver elegant, touch-enabled WPF applications using the platform you know and love. The WPF Subscription helps you leverage your current investments and address customer needs via a comprehensive range of WPF controls that support touch on both Windows 7 and Windows 10.

Sec 508 and Accessibility

The DevExpress WPF Subscription makes it easy to create WPF applications that meet government regulations regarding web accessibility. Sec 508 and Accessibility Guidelines 1.0 support is available for key DevExpress WPF controls.

Straightforward Localization

All DevExpress WPF controls can be easily localized using satellite resource assemblies. DevExpress delivers satellite assemblies for a large variety of languages and cultures. To make it easy to get started, resource files for four cultures are included to our installation: German, Japanese, Russian, and Spanish. If you need to modify our shipping resources or create satellite assemblies for a different language, simply use our Online Localization Service, a free tool for our active WPF subscribers. Online Localization Service

MVVM Support

DevExpress WPF Controls have been engineered to support the Model-View-ViewModel development pattern. Controls such as the DevExpress WPF Grid provide the same level of MVVM support as the standard Microsoft Data Grid along with additional features not available from Microsoft. DevExpress controls allow you to generate columns based on data and customize them using WPF styles without limitations. Learn more