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

Free 30-Day Trial

WinForms Spreadsheet Control | DevExpress

Print / Export to PDF

The easiest and fastest 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.

Free 30-Day TrialWatch the video

The product is always top class, and the support is second to none. Professional Product, Professional Support and Professional output. Steve O'Connor, Technical Director
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.

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

Free 30-Day Trial

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.

Free 30-Day Trial

Mail Merge - WinForms Spreadsheet Control, DevExpress

Analyze & Visualize Data

Summarize and analyze large amounts of data

Embed 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.

Once you've set up the data layout you need, add a chart to present information graphically. Our 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 30-Day Trial

Analyze and Visualize Spreadsheet Data - WinForms Spreadsheet Control, DevExpress

Conditional Formatting

Intuitively present workbook data to your users

Similar to charts and sparklines, conditional formatting provides another way to visualize data. You can 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.

You can also use cell styles to apply predefined formats, and other manual formatting options to highlight important data. Cell value formatting options include:

  • Style Flags, Predefined Cell Styles and Formats
  • Rich Text Formatting
  • Format as Table
  • Custom Draw API

Free 30-Day Trial

Conditional Formatting - WinForms Spreadsheet Control, DevExpress

Group, Sort and Filter

Organize and search data easily

  • 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.

Free 30-Day Trial

Outlines, Data Sorting and Filtering - WinForms Spreadsheet Control, DevExpress

Protection & Security

Protect your work and prevent anauthorized 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 30-Day Trial

Worksheet Protection - WinForms 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
  • Predefined In-cell Editors for List, Date-Time and Boolean Values
  • Custom Editors for Worksheet Cells
  • Copy / Cut / Paste / Paste Special
  • Insert / Delete Rows and Columns
  • Redo / Undo
  • Display Customizable Error Messages
  • Highlight Invalid Values

You can bind a worksheet or cell range to various data source types: ADO.NET, SQL, custom objects, etc. A cell range can also be used as a data source for any data-aware control.

Free 30-Day Trial

Edit, Format and Protect Data - WinForms Spreadsheet Control, DevExpress

Best in Class Tools

DevExpress is honored to have been voted best in class 19 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.

19 VSM Awards in 2023 x19
20 VSM Awards in 2022 x20
20 VSM Awards in 2021 x20
18 VSM Awards in 2020 x18

60 Day Unconditional Money Back Guarantee

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
.NET 6 / .NET 7 / .NET 8 Support
Data Grid
DirectX Hardware Acceleration
HTML & CSS Markup Support
Charting
Gantt
Spreadsheet
Rich Text Editor
Calendar & Scheduling
Diagrams
Ribbon
Toolbar-Menu
DirectX Form
Dock Windows
Pivot Grid
Tree List
TreeMap
Property Grid
PDF Viewer
Sankey Diagram
Sunburst
Layout Manager
Map Control
Heat Map
Gauge Controls
Navigation Pane
Tile Control
Live Tile Manager
Printing & Exporting
Spell Checker
Data Editors
MVVM Framework
Themes and Skinning
WPF Controls
.NET 6 / .NET 7 / .NET 8 Support
Data Grid
Tree List
Property Grid
Charting
Pivot Grid
Calendar & Scheduling
Spreadsheet
Rich Text Editor
Spell Checker
PDF Viewer
Diagrams
Sankey Diagram
Ribbon
Toolbar-Menu
TreeView
Dock Windows
Layout Manager
Navigation Controls
Data Editors
Map Control
Heat Map
Sunburst
TreeMap
Gantt Control
Gauge Controls
Printing and Exporting
MVVM Framework
Application Themes
Blazor UI Components
Grid
Bar Gauge
Charts
Data Editors
Dialogs & Windows
File Management
HTML Editor
PDF Viewer
Layout
Map
Navigation
Pivot Grid
Reports
Rich Text Editor
Scheduler
TreeList
BI Dashboard
.NET MAUI Controls with Support
Data Grid
CollectionView
Charts
Scheduler
PDF Viewer
Bottom Sheet
Data Editors
Data Form & Form Components
HTML Editor
Image Control
Layout Panels
Popup
Circular Gauge
Shimmer Control
Tabs
Toolbar
Tree View
.NET MAUI Project Templates
Office File API Support
jQuery Components
Data Grid
Charting
Calendar & Scheduling
Pivot Grid
TreeList
HTML/Markdown Editor
Diagram
Gantt
File Management
Form Layout
Data Editors
Gauge Components
Map Components
Navigation and Layout
Dialogs and Notifications
Actions and Lists
Data Export
Theme Builder
Angular Components
Data Grid
Charting
Calendar & Scheduling
Pivot Grid
TreeList
HTML/Markdown Editor
Diagram
Gantt
File Management
Form Layout
Data Editors
Gauge Components
Map Components
Navigation and Layout
Dialogs and Notifications
Actions and Lists
Data Export
Theme Builder
React Components
Data Grid
Charting
Calendar & Scheduling
Pivot Grid
TreeList
HTML/Markdown Editor
Diagram
Gantt
File Management
Form Layout
Data Editors
Gauge Components
Map Components
Navigation and Layout
Dialogs and Notifications
Actions and Lists
Data Export
Theme Builder
Vue Components
Data Grid
Charting
Calendar & Scheduling
Pivot Grid
TreeList
HTML/Markdown Editor
Diagram
Gantt
File Management
Form Layout
Data Editors
Gauge Components
Map Components
Navigation and Layout
Dialogs and Notifications
Actions and Lists
Data Export
Theme Builder
ASP.NET Web Forms Controls
Data Grid
Charting
Ribbon
Spreadsheet
Rich Text Editor
Calendar & Scheduling
Card View
Site Navigation
Page Layout
Docking and Popups
Pivot Grid
Tree List
TreeView
Vertical Grid
HTML Editor
Gauge Controls
Data Browsing
Image Browsing
File Management
Multi-Purpose Site Controls
Printing & Exporting
Spell Checker
Data Editors
Themes and Skinning
Diagram
Gantt
ASP.NET MVC Extensions
Data Grid
Charting
Ribbon
Spreadsheet
Rich Text Editor
Calendar & Scheduling
Card View
Page Layout
Site Navigation
Docking and Popups
Pivot Grid
Tree List
TreeView
Vertical Grid
HTML Editor
Data Browsing
Image Browsing
File Management
Printing & Exporting
Spell Checker
Data Editors
Themes and Skinning
Diagram
Gantt
ASP.NET MVC Client-Side Controls
Data Grid
Charting
Calendar & Scheduling
Pivot Grid
TreeList
HTML/Markdown Editor
Diagram
Gantt
File Management
Form Layout
Data Editors
Gauge Controls
Map Control
Web Navigation and Layout
Dialogs and Notifications
Multi-Purpose Web Controls
Data Export
Theme Builder
ASP.NET Core Controls
.NET 6 / .NET 7 / .NET 8 Support
Data Grid
Charting
Calendar & Scheduling
Pivot Grid
TreeList
HTML/Markdown Editor
Diagram
Gantt
File Management
Form Layout
Data Editors
Gauge Controls
Map Control
Web Navigation and Layout
Dialogs and Notifications
Multi-Purpose Web Controls
Data Export
Theme Builder
ASP.NET Core Office Controls
.NET 6 / .NET 7 / .NET 8 Support
Spreadsheet
Rich Text Editor
Printing & Export
ASP.NET Bootstrap Controls
Data Grid
CardView
Charting
Ribbon
Rich Text Editor
File Manager
Scheduler
Site Navigation and Layout
Sparkline
Spreadsheet
Data Editors
Themes and Skinning
Reporting
.NET 6 / .NET 7 / .NET 8 Support
Visual Studio Report Designer
WinForms Document Viewer
WinForms End-User Report Designer
Document Viewer (ASP.NET Web Forms, MVC, Core)
Web Report Designer (ASP.NET Web Forms, MVC, Core)
Native Blazor Document Viewer (Server, WebAssembly)
Blazor Web Report Designer (Server, WebAssembly)
WPF Document Viewer
WPF End-User Report Designer
Native Angular Document Viewer
Angular End-User Report Designer
Native React Document Viewer
React End-User Report Designer
XPO - ORM Library
High Performance ORM
Full Support for 12 Database Engines
.NET 6 / .NET 7 / .NET 8 Support
Visual Data Model Designer
Office File API (Basic)
.NET 6 / .NET 7 / .NET 8 Support
Export to Excel (XLSX, XLS, CSV)
Word Processing Document API (create, edit, update DOC/DOCX, RTF, HTML, etc.)
Office File API (Complete)
.NET 6 / .NET 7 / .NET 8 Support
Non-Windows Environment Support (Linux, macOS, Azure, AWS)
Spreadsheet Document API (create, edit, update XLSX, XLS, CSV)
Export to Excel (XLSX, XLS, CSV)
Word Processing Document API (create, edit, update DOC/DOCX, RTF, HTML, etc.)
PDF Document API
Digital Signature API
Barcode Generation API
Zip Compression and Archive API
Unit Conversion API
Business Intelligence Dashboard
.NET 6 / .NET 7 / .NET 8 Support
WinForms Dashboard Viewer
WinForms End-User Dashboard Designer
WPF Dashboard Viewer
Blazor Dashboard Component
ASP.NET Core Dashboard Control (includes End-User Designer)
ASP.NET Web Forms Dashboard Control (includes End-User Designer)
ASP.NET MVC Dashboard Control (includes End-User Designer)
HTML JS Dashboard Control (includes End-User Designer)
Dashboard Component for Angular (includes End-User Designer)
Dashboard Component for React (includes End-User Designer)
Dashboard Component for Vue (includes End-User Designer)
VS Dashboard Designer
XAF - Cross-Platform .NET App UI
.NET 6, 7, 8 / .NET Framework
WinForms, ASP.NET Core Blazor, ASP.NET Web Forms
Backend Web API Service
Entity Framework Core and XPO ORM Support
Multi-Tenancy Support
Role-based Access Control, Permission Management
Administrative UI (Manage Users & Roles at Runtime)
Audit Trail (History of Data Changes)
Validation (Prevent Data Errors)
Reporting (Shape, Export & Print Data)
Analytics (Dashboard, Chart, Pivot, Map)
Office Documents (Edit Rich Text & Spreadsheets)
File Attachments (Store Custom Files)
Clone Object (Copy Data Records)
Business Process Management (Workflow & State Machine)
Conditional Appearance (Manage UI Element State)
Event Planning (Scheduler & Notifications)
Tree List Editors (Organize Hierarchical Data)
Localization
Themes
.NET App Security & Web API Service
Entity Framework Core ORM Support
XPO ORM Support
Role-based Access Control & Permission Management
ASP.NET Core Web API / OData Service for CRUD and Authorization
Administrative UI to Manage Users and Roles at Runtime
Download Reports
Download File Attachments
Obtain Localized Strings
Validate Data
Audit Data Changes
CodeRush for Visual Studio
VS 2022 Support
VS 2019 Support
VS 2017 Support
VS 2015 Support
Roslyn-Powered Superior Performance
C#, VB.NET, XAML
TestCafe Studio: Functional Web Testing
Coded UI Support for WinForms Controls
Source Code *
WinForms Controls
ASP.NET Controls
WPF Controls
JavaScript - jQuery, Angular, React
Blazor UI Components
Reporting
.NET MAUI Controls with Support
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.

190+ WinForms Controls


Our WinForms Subscription includes over 190 UI controls and libraries along with 60+ individual chart types. Here are some of the products included in this subscription:

 

Start your free 30-day trial today!

Download our fully-functional 30-day trial today and
experience the DevExpress difference today.

 

Download Free Trial