: DevExpress ASP.NET Spreadsheet Control
Automatically Generated UI

The DevExpress Spreadsheet provides the UI experience your end users have come to expect from today's most popular office productivity suite.


: DevExpress ASP.NET Spreadsheet Control
Straightforward and Easy-to-Use Spreadsheet

The new DevExpress ASP.NET Spreadsheet is an Excel inspired control and allows you to introduce spreadsheet functionality to any ASP.NET 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.

Help Topic: Supported Formats


: DevExpress ASP.NET Spreadsheet Control
Automated Formula Calculation Engine

DevExpress formula calculation results have been engineered to closely match those of Microsoft Excel. A spreadsheet formula is an equation that performs a calculation on numbers, functions and values of one or more cells.

Demo: Dynamic Sheet Generation


: DevExpress ASP.NET Spreadsheet Control
Built-in Spreadsheet Functions

The DevExpress Spreadsheet Control supports a comprehensive range of functions for use within formulas. Functions are compatible with Microsoft Excel.

Demo: Formulas


: DevExpress ASP.NET 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:

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

Help Topic: Cells and Cell Ranges | Help Topic: Cell Referencing


: DevExpress ASP.NET Spreadsheet Control
Worksheet Management

To organize worksheets in a workbook, you can create new worksheets, copy, rename and delete existing worksheets.

Help Topic: Worksheets


: DevExpress ASP.NET Spreadsheet Control
Rows and Columns

You can insert, copy, and delete rows and columns, adjust row height and column width.

Help Topic: Rows and Columns


: DevExpress ASP.NET Spreadsheet Control
Charting

Charts can help you display data in ways that are meaningful to your customer. Select from a variety of chart types (such as a bar chart or a line chart) and their subtypes (such as a stacked horizontal pyramid chart or a 3-D line chart).

Demo: Charts


: DevExpress ASP.NET Spreadsheet Control
Pictures

You can insert, move, change, transform and delete pictures incorporated into a worksheet.

Demo: Images


: DevExpress ASP.NET Spreadsheet Control
Cell Formatting

Proper cell formatting improves worksheet appearance, and allows end-users to read, find and understand worksheet data more easily. You can specify the following format attributes for cells:

  • Cell font settings (font name, size, color, style, etc.)
  • Cell background
  • Cell content alignment (vertical and horizontal alignment, indent and text wrapping)
  • Cell borders
  • Number formats


: DevExpress ASP.NET Spreadsheet Control
Workbook and Worksheet Element Protection

DevExpress ASP.NET Spreadsheet Control provides support for worksheet and workbook element protection defined within documents. When the Spreadsheet opens a document that contains protected elements, the control prevents them from being modified by end-users. For instance, the Spreadsheet can lock the workbook’s structure preventing users from adding, deleting, hiding or displaying worksheets. Or, the Spreadsheet can prevent end-users from editing the contents of locked cells within a protected worksheet. This helps obscure data or formulas that might confuse users and prevents them from viewing or making changes to that data.


: DevExpress ASP.NET Spreadsheet Control
Printing

DevExpress ASP.NET Spreadsheet Control allows end-users to print workbook contents via its built-in Ribbon UI. Before printing a workbook, users can specify print settings for each worksheet individually using the Page Setup Ribbon tab. To start printing, click the Print item within the Ribbon's File tab and this will invoke a browser-specific print dialog. The options available within the print dialog will vary based upon the client's browser.


: DevExpress ASP.NET Spreadsheet Control
Text Search

The DevExpress ASP.NET Spreadsheet Control allows end-users to easily locate data within any worksheet. To execute a search, click the new 'Find & Select' Ribbon item (or press CTRL+F), enter text within the Find box and click the Find All button. The Spreadsheet will display search results as clickable table rows. Results will include each cell reference and its associated value. A click on a row highlights the corresponding cell in the worksheet.


: DevExpress ASP.NET Spreadsheet Control
Dynamic Chart Customization

Once a chart is created, end-users can customize its settings (type, layout, styles, underlying data range, etc.) via the built-in context menu.


Download the Free Trial

Includes 30 days of free tech support

Buy it Today

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

$899.99

Download Free Trial

100% ASP.NET. 100% DevExpress.

The 100 ASP.NET AJAX Controls and 55 MVC Extensions that make up the DevExpress ASP.NET Subscription have been engineered to address the UI, analytics and reporting requirements for a broad range of solutions targeting all major web browsers. 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.
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