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