Excel Inspired Spreadsheet for WinForms

Create, read and write Excel and OpenXML files

The DevExpress WinForms Spreadsheet control allows you to create high-impact business data analysis solutions that emulate the look, feel and capabilities of Microsoft Excel®. It includes full integration with the DevExpress Ribbon control so you can deliver Excel inspired functionality with minimal effort.

Our WinForms 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 the same file formats as nearly every version of Microsoft Excel:

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

 

WinForms Spreadsheet Control | DevExpress

Print / Export to PDF

The easiest way to print your workbook

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 and many other page settings.

You can also shrink a worksheet to fit on one or multiple pages, insert row and column page breaks, add headers and footers, incorporate page numbers, current date and file name to printed worksheets.

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

Print and Export to PDF / HTML - WinForms Spreadsheet Control, DevExpress

400+ Functions

Excel compatible functions are built-in

Over 400 built-in functions (mathematical, statistical, financial, logical, etc.) with array formula support allow you to enter formulas and perform calculations of any complexity. 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.

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

RTD Function
Our WinForms Spreadsheet includes RTD (Real-Time Data) function support.
See how easy it is to connect to your favorite RTD provider.

Formula AutoComplete
Eliminate typing and syntax errors when creating and editing formulas with the built-in Formula AutoComplete feature.

Excel Inspired Functions / Formulas - WinForms Spreadsheet Control, DevExpress

Mail Merge

Create multiple documents at once

Automatically create multiple documents based on a single template and include unique data from a data source. Integrated mail merge tools include:

  • Mail Merge Ribbon UI
  • Mail Merge Design View
  • Field List Panel
  • Parameters Panel
  • Mail Merge Functions (FIELD, FIELDPICTURE, RANGE, PARAMETER)

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.

You can also create master-detail reports of any complexity without writing code.

 

Mail Merge - WinForms Spreadsheet Control, DevExpress

Learn More about Our WinForms Spreadsheet

Learn More

Analyze and Shape Workbook Data

Intuitively present workbook data to your users. Analyze large amounts of data with pivot tables. Visualize workbook data using sparklines and 2D-3D chats.

Pivot Tables

Summarize, analyze, explore, and present your worksheet data.

Charts & Sparklines

Present information graphically within worksheets.

Sort & Filter Data

Sort and filter data against worksheet columns.

Text Search

Find / Replace

Conditional Formatting

Highlight cell values for maximum data clarity.

Outlines

Arrange related columns or rows into groups and display summaries for each group.
"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

Edit, Format and Protect Spreadsheet Data

The DevExpress WinForms Spreadsheet control gives you the total control over cell editing, data validation, annotating, cell value formatting and user permissions. Your data will always be clear, accurate and secure.

Data Editing

Deliver high-impact data editing experiences within your apps.

Data Validation

Reduce data entry errors and visually inform users of invalid input.

Protection & Security

Use document protection and password encryption to prevent unauthorized access.

Bind to Data

ADO.NET / SQL / Custom Objects

Cell Formatting / Rich Text

Create professional-looking worksheets that display your data effectively.
"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

Insert Comments, Hyperlinks and Graphics

Our WinForms Spreadsheet control allows you to add elements such as hyperlinks, symbols, images and shapes. You can also insert comments to worksheet cells to offer tips to users.

Comments

Excel-inspired comments

Hyperlinks

Provide quick access to files, web pages, etc.

Shapes

View, print and export documents that contain shapes.

Pictures

Embed images in documents.

Symbols

Insert symbols and special characters.

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 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
UWP Controls
Reporting
WinForms Report Viewer
WinForms End-User Report Designer
HTML5 Report Viewer
ASP.NET Web Forms Report Viewer
ASP.NET Web Forms End-User Report Designer
ASP.NET MVC Report Viewer
ASP.NET MVC End-User Report Designer
ASP.NET Core Report Viewer
ASP.NET Core End-User Report Designer
Blazor Report Viewer
Blazor End-User Report Designer
WPF Report Viewer
WPF End-User Report Designer
XPO - ORM Library
Office File API (Basic)
.NET Standard 2.0+ Support (Windows, Linux, MacOS)
Excel Export Library
Word Processing Document API (DOC, RTF)
Office File API (Complete)
.NET Standard 2.0+ Support (Windows, Linux, MacOS)
XAF - App Framework
Xamarin.Forms UI Controls
Native Mobile UI Controls
CodeRush
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 Studio, and Report & Dashboard Server.

Additional Info

WinForms Themes and App Skins

The DevExpress WinForms Subscription ships with over 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 accessibility. Sec 508 and Accessibility Guidelines 1.0 support is available for key DevExpress WinForms controls. Download VPAT

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