Top New Features

Based on great feedback from users such as yourself, our WinForms Spreadsheet continues to evolve. See what we've been up to in recent release cycles.

Read More

400+ Functions

Numerous built-in functions (mathematical, statistical, financial, logical, etc.) allow you to enter formulas and perform calculations of any complexity.

Read More

Inspired by Excel

With our WinForms Spreadsheet control, you can create high-impact business solutions that emulate the look, feel and capabilities of Microsoft Excel®.

Watch the Video
Documents & Worksheets
Protection & Encryption
Use document protection and password encryption to prevent unauthorized access.
Protection & Encryption

The DevExpress WinForms Spreadsheet control enables you to use password encryption to prevent unauthorized users from opening or modifying your workbooks. You can also 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, a range in a protected worksheet can be unlocked for specific users while other users may be prompted for a password when they try to edit the range.

Data Validation
Reduce data entry errors and visually inform users of invalid input.
Data Validation
The Spreadsheet Control includes data validation support. With it, you can control the manner in which data is entered. An error message is displayed if a value violates restrictions you've specified. You can use predefined validation rules or implement them manually using Data Validation API.
Data Binding
ADO.NET / SQL / Custom Objects
Data Binding

The DevExpress Spreadsheet control allows you to bind a worksheet or cell range to various data source types: ADO.NET data sets, SQL databases, custom objects, etc. A cell range can also be used as a data source for any data-aware control. All data-related modifications affecting the worksheet are immediately propagated to bound controls. Changes made within external controls are immediately reflected in the worksheet.

Comments
Excel-Inspired Comments
Comments
You can annotate worksheets by using comments. End-users can add new comments, edit, hide or delete existing comments, move and resize the comment box.
Cell Formatting & Styles
Create professional-looking worksheets that display your data effectively.
Cell Formatting & Styles
The DevExpress Spreadsheet provides several fast and simple ways to create professional-looking worksheets that display your data effectively. You can use cell styles to apply predefined formats, and other manual formatting features to highlight important data.
Load / Save Documents
XLSX, XLS, XLTX, XLTM, CSV, TXT and more...
Load / Save Documents

The DevExpress Spreadsheet control supports the following file formats to import and export data:

  • XLS, XLSX, XLSM;
  • XLT, XLTX, XLTM;
  • CSV;
  • TXT;
  • PDF (export only);
  • HTML (export only).
"The response from DevExpress is always prompt, detailed and typically includes a code sample. Have used their suite for 4 years and never regretted my choice for one second." Jim Thomas
Data Shaping & Analysis
Pivot Tables
Summarize, analyze, explore, and present your worksheet data.
Pivot Tables

An Excel-like pivot table engineered for multi-dimensional data analysis and cross-tab reporting. Pivot Tables are highly flexible and can be quickly adjusted depending on how you need to display your results.

To create a pivot table, click the PivotTable button on the Insert tab.

Functions & Array Formulas
Over 400 built-in functions. Custom functions.
Functions & Array Formulas

Numerous built-in functions (mathematical, statistical, financial, logical, etc.) allow you to enter formulas and perform calculations of any complexity.

The WinForms Spreadsheet API allows you to create your own functions. Custom functions are available for all spreadsheet calculations, and can be used in formulas. Custom functions are not saved in a workbook file, and should be added in code.

Charts
Present information graphically within worksheets.
Charts

The DevExpress Spreadsheet control allows you to summarize worksheet data visually using a comprehensive collection of charts. Charts display data series visually to make it easier to understand large quantities of data and the relationship between different series of data.

Sorting & Filtering Data
Sort and filter data against worksheet columns.
Sorting & Filtering Data

As you would expect, our WinForms Spreadsheet supports sorting against worksheet columns. You can sort data by text (alphabetically, according to the current culture), numbers, dates and time.

Filtering helps you to find information quickly. You can filter data in a range or table. Using built-in comparison operators such as 'greater than' and 'begins with' you can show the data you want and hide the rest.

Conditional Formatting
Highlight cell values for maximum data clarity.
Conditional Formatting
The DevExpress 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. At runtime, end-users can easily apply style conditions by activating the Spreadsheet's popup menu.
Outlines
Arrange related columns or rows into groups and display summaries for each group.
Outlines

Outlining data makes your data easier to view. When you outline Spreadsheet data, you group worksheet data into different levels based on column and row headings. Once applied, you can expand the outline to view any pertinent detail data by clicking a plus sign. To collapse a group of cells, click a minus sign.

You can use the numbers to collapse or expand groups by level You can also quickly display as little or as much information by clicking the level symbols to the left of your worksheet.

"For years now I've enjoyed working with DevExpress controls - both WinForms and WPF. What I enjoy most is the stability of the products and super-fast and accurate support from your support team." Robert Kurtanjek
Spreadsheet Customization
Custom Cell Editors
Deliver high-impact data editing experiences within your apps.
Custom Cell Editors

The DevExpress Spreadsheet control allows you to embed custom data editors into worksheet cells. You can use predefined in-place editors or handle the 'CustomCellEdit' event and assign your own editor to worksheet cells.

Custom Draw
Draw worksheet cells, row and column headers manually.
Custom Draw
The DevExpress WinForms Spreadsheet control allows you to custom draw worksheet cells, row and column headers by handling the 'CustomDrawCell' and 'CustomDrawCellBackground' events.
Master-Detail
Display master-detail relationships of any complexity.
Master-Detail
The DevExpress WinForms Spreadsheet control allows you to create master-detail reports without writing code.
Text Search & Highlighting
Find / Replace
Text Search & Highlighting
A simple and quick way to find cell values. The 'Find and Replace' dialog removes all complexities associated with data searching. This dialog allows users to enter a search string and initiate a search against all values displayed in the worksheet.
Rotated Text
Align text properly.
Rotated Text
DevExpress Spreadsheet gives you the ability to rotate text within individual spreadsheet cells. Rotated text can be printed and exported to PDF format.
"With over 30 years of programming experience, I can honestly state that DevExpress products are mature and ready to take on the most demanding task." Ron Lindsey
Merge, Print & Export
Mail Merge
Create multiple documents at once.
Mail Merge

The DevExpress WinForms Spreadsheet control provides the Mail Merge feature that simplifies the creation of a set of documents that are similar but contain unique and variable data elements.

Our Spreadsheet Mail Merge Data Source Wizard allows you to connect to various data source types (Microsoft SQL Server, Microsoft Access, Entity Framework, etc.), and save the template with the bound data source to a file (XLS/XLSX format). This template can then be used to quickly create new documents and reports as needed.

WYSIWYG Printing
The easiest way to print the contents of your workbook.
WYSIWYG Printing
Turn the contents of your workbook into a printed report with a simple method call or using the Print Dialog. You can customize and preview print output using the Print Setup dialog.
Export to PDF
Data export is fully formatted.
Export to PDF

The DevExpress Spreadsheet control supports the following file formats to export data:

  • PDF
  • HTML
Headers & Footers
Add information to the top and bottom of a printed sheet.
Headers & Footers
The DevExpress Spreadsheet control allows you to add headers and footers at the top and bottom of a printed worksheet. You might create a header or footer that has page numbers, the date, and the name of your file using the Header/Footer dialog.
Print Titles
Make your printed copy easier to read.
Print Titles

Our Spreadsheet control allows you to specify rows and columns that will be printed on each printed page. This can make your printed copy easier to read.

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
ASP.NET WebForms Controls
Printing & Exporting
ASP.NET MVC Extensions
Printing & Exporting
ASP.NET Bootstrap Controls
Themes and Skinning
ASP.NET Core Bootstrap Controls
Themes and Skinning
JavaScript - jQuery, Angular, React
JavaScript - ASP.NET MVC & Core
UWP Controls
Reporting
WinForms Report Viewer
WinForms End-User Report Designer
HTML5 Report Viewer
ASP.NET Report Viewer
ASP.NET End-User Report Designer
MVC Report Viewer
MVC End-User Report Designer
WPF Report Viewer
WPF End-User Report Designer
Office File API (Basic)
Excel Export Library
Word Processing Document API (DOC, RTF)
Office File API (Complete)
Spreadsheet Document API (XLSX, XLS)
Excel Export Library
Word Processing Document API (DOC, RTF)
PDF Document API
DevExpress Snap Report API
Barcode Generation API
Zip Compression and Archive API
Unit Conversion API
Native Mobile UI Controls
Charting Library
iOS Controls
Android Controls
Xamarin Wrappers
CodeRush
VS 2017 Support
VS 2015 Support
Roslyn-Powered Superior Performance
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
UWP Controls
JavaScript - jQuery, Angular, React
XPO - ORM Library
Office File API
Data Visualization Dashboard
eXpressApp Framework
Technical Support
Priority Support

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

Additional Info

WinForms Themes and App Skins

The DevExpress WinForms Subscription ships with 50 custom designed and highly polished themes for your next WinForms application. You can use each of these themes easily, without modification or manipulate them using our free WinForms Skin-Theme Editor application. Learn more

Touch Enabled User Experience

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

Sec 508 and Accessibility

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

Straightforward Localization

All DevExpress WinForms controls can be localized using satellite resource assemblies. DevExpress delivers satellite assemblies for a large variety of languages and cultures. To help you get started, resource files for four cultures are included in 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 WinForms subscribers. Online Localization Service

Testing Support

The DevExpress Universal Subscription includes built-in support for Microsoft's CodedUI. Unlike many vendors claiming support for Coded UI through the simple use of MSAA, DevExpress controls go the extra mile to make certain that individual controls fully comply with Microsoft's testing framework. We don't simply support Coded UI; we support it to the maximum extent possible. Note: CodedUI support requires purchase of the DevExpress Universal Subscription. Learn more

MVVM Framework

The DevExpress MVVM Framework ships with features that are absent in WinForms, but essential to MVVM development. These missing features include bindings, commands, UI triggers, behaviors etc. Our Framework includes all of these along with a straightforward API to make WinForms app development more efficient. Learn more