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

 

Watch the video

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.

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

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
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
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:

  • Predefined Cell Styles and Formats
  • Style Flags
  • Rich Text Formatting
  • Format as Table
  • Custom Draw API
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.

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.

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.

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

Best in Class Tools

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

x18
x19
x19
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
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)
Office File API (Complete)
.NET Standard 2.0+ Support (Windows, Linux, MacOS)
XAF - App Framework
User Authentication/Group Authorization API (.NET)
for Entity Framework Core ORM
for XPO ORM
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.