: DevExpress WinForms Spreadsheet Control
Microsoft Office Inspired UI

The DevExpress Spreadsheet provides the UI experience your end users have come to expect from today's most popular office productivity suite. It includes full integration with the DevExpress Ribbon control so you can quickly deliver stunning applications with minimal effort.


: DevExpress WinForms Spreadsheet Control
Straightforward and Easy-to-Use Spreadsheet

The new DevExpress WinForms Spreadsheet is an Excel inspired control and allows you to introduce spreadsheet functionality to any WinForms application with absolute ease. It can load, convert and save workbooks to the XLS binary file format and can export and import XLSX, CSV and TXT files.


: DevExpress WinForms Spreadsheet Control
Protection

You can prevent users from modifying workbooks, worksheets, and specific ranges. Different sheets can have different levels of protection. A range in a protected worksheet can be unlocked for specific users, other users may be prompted for a password when they try to edit the range.


: DevExpress WinForms Spreadsheet Control
Charts

You can summarize worksheet data visually and make data interpretation easier using a variety of charts. Create a simple chart and then customize its appearance for maximum effect. Apply one of the predefined chart layouts and styles or adjust chart elements manually. Use Chart API to create and modify a chart in code

  • Column Charts
  • Line Charts
  • Pie Charts
  • Bar Charts
  • Area Charts
  • Scatter Charts
  • Stock Charts
  • Radar Charts


: DevExpress WinForms Spreadsheet Control
Automated Formula Calculation Engine

DevExpress formula calculation results have been engineered to closely match those of Microsoft Excel. Automatic and manual calculation modes are supported. You can evaluate worksheet formulas in your application code using the FormulaEngine object. FormulaEngine provides the capability to parse a formula into an expression tree, modify it and rebuild the string expression.


: DevExpress WinForms Spreadsheet Control
Cell References

A formula can contain references to other cells or cell ranges within the same or different worksheets. The following references are supported:

  • A1 and R1C1 References
  • Relative, Absolute and Mixed References
  • Cross-Worksheet References
  • 3D References
  • Structured References

The Name Manager helps end-users to manage named ranges and defined names.


: DevExpress WinForms Spreadsheet Control
Built-in Spreadsheet Functions

The DevExpress Spreadsheet Control supports a comprehensive range of functions for use within formulas. Function categories include:

  • Mathematical
  • Statistical
  • Date & Time
  • Text
  • Financial
  • Logical
  • Lookup & Reference
  • Engineering
  • Information
  • Database
  • Web
  • Real-Time Data function

You can also create your own custom functions (UDF or user-defined functions).


: DevExpress WinForms Spreadsheet Control
Mail Merge

The DevExpress WinForms Spreadsheet offers comprehensive mail merge functionality for a wide range of business requirements. With it, you can automatically generate personalized letters and a variety of business documents, as well as compose master-detail reports of any complexity (including catalogs, header/detail invoices or statements). SpreadsheetControl's mail merge tools allow your end-users to visually design templates and preview mail merge results on-the-fly.


Download the Free Trial

Includes 30 days of free tech support

Buy it Today

Part of the WinForms Subscription
Pricing starts at only
Get started today and see why tens of thousands of developers
worldwide choose DevExpress.

$999.99

Download Free Trial

Everything you'll need for your next WinForms project.

The 160 controls and libraries that make up the DevExpress WinForms Subscription have been engineered to address the UI, analytics and reporting requirements for a broad range of solutions targeting Windows®. If you are a WinForms developer and are ready to experience the #1 selling WinForms control library on the market today, download your free trial today or explore the individual controls that ship as part of this subscription below.

Office-Inspired
Create compelling business solutions that emulate the look, feel and capabilities of Microsoft Office®.
Reports & Analytics
Harness the power of information and present it to your users so it's always easy-to-use and always customizable.
Windows Modern UI
Target next-gen Windows devices and bring the power of touch and Modern UI to your next WinForms project.
Navigation & Layout
Reproduce the advanced and highly flexible user interfaces of today's most popular Windows applications.
LIVE CHAT

Chat is one of the many ways you can contact members of the DevExpress Team.
We are available Monday-Friday between 7:30am and 4:30pm Pacific Time.

If you need additional product information, write to us at info@devexpress.com or call us at +1 (818) 844-3383

FOLLOW US

DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, along with high-performance HTML JS Mobile Frameworks for developers targeting iOS, Android and Windows Phone. Whether using WPF, ASP.NET, WinForms, HTML5 or Windows 10, DevExpress tools help you build and deliver your best in the shortest time possible.

Copyright © 1998-2017 Developer Express Inc.
All trademarks or registered trademarks are property of their respective owners