Microsoft Excel Compatibility

Create, read, and write Excel and OpenXML files

The DevExpress ASP.NET Spreadsheet control for Web Forms and MVC 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 ASP.NET Ribbon control so you can deliver Excel inspired functionality with minimal effort.

Our Web 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 nearly all Microsoft Excel document formats including:

  • XLS, XLSX, XLSM, XLSB, BIFF5
  • XLT, XLTX, XLTM
  • CSV
  • TXT

Free TrialSee Demo

Microsoft Excel Compatibility - ASP.NET Spreadsheet Control | DevExpress

400+ Formulas & Functions

Excel compatible functions are built-in.

Over 400 built-in functions with array formula support allow you to create formulas and perform high-precision and multi-threaded calculations at incredibly fast speeds.

From basic mathematical functions to complex formulas with statistical and financial functions, DevExpress ASP.NET Spreadsheet control includes everything you need to incorporate Excel-inspired data analysis functionality in your web app.

Free TrialSee Demo

Formulas and Functions - ASP.NET Spreadsheet Control | DevExpress

Mail Merge

Auto-generate multiple documents at once.

Automatically create multiple documents based on a single template and include unique data from a data source. Supported mail merge functions (placeholders):

  • FIELD
  • FIELDPICTURE
  • RANGE
  • PARAMETER

Free TrialSee Demo

We've used DevExpress Controls for a few years now and are more than happy with it. It saves us a lot of time and helps us make a good impression on our customers. Fredy Wenger / CEO and founder MATRIX Solutions AG
Mail Merge - ASP.NET Spreadsheet Control | DevExpress

Pivot Tables, Charts, Sparklines

Summarize and visualize large amounts of data.

Our Web Spreadsheet control supports Excel-like pivot table, shapes, sparklines (Line, Column, Win/Loss), and a wide range of 2D/3D charts:

  • Column and Bar Charts
  • Pie and Doughnut Charts
  • Area and Line Charts
  • Scatter, Radar, and Bubble Charts
  • Box and Whisker Charts
  • Histogram and Pareto Charts
  • Treemap and Sunburst Charts
  • Waterfall and Funnel Charts
  • Stock Charts

Free TrialSee Demo

Pivot Tables, Charts, Sparklines - ASP.NET Spreadsheet Control | DevExpress

Data Editing & Validation

Keep your data clear and accurate.

The DevExpress ASP.NET Spreadsheet control gives you the total control over cell editing. Our Excel-inspired Data Validation engine helps reduce data entry errors, improve accuracy and data consistency when modifying worksheet cells. The validation engine has been designed so you and your end-users can easily define restrictions and provide notifications as to what can be entered into spreadsheet cells.

Just like Microsoft Excel, our Spreadsheet includes an AutoFilter - designed to filter data against column values and to display only those rows that meet specific criteria.

As you would expect, our ASP.NET Spreadsheet supports sorting against an unlimited number of columns. You can sort data by text (alphabetically, according to the current culture), numbers, date and time.

Free TrialSee Demo

Data Editing and Validation - ASP.NET Spreadsheet Control | DevExpress

Document Security

Protect your work, prevent anauthorized access.

You can password-protect your Excel worksheets/workbooks and prevent unauthorized access. Security options include:

  • Restrict Document Modification
  • Encrypt a Document with a Password
  • Specify a Password to Open or Edit a Document
  • Grant User Permissions

Free TrialSee Demo

I've been using your tools since 2008 and my productivity and output has increased significantly due to your tools. Robert Fahey / Adacel Systems Inc.
Document Security - ASP.NET Spreadsheet Control | DevExpress

Elegant Web Themes

Because elegance matters.

Choose from over 20 highly polished, lightweight, and fully responsive web themes. Deliver unique user experiences that meet and exceed expectations across any device (desktop, tablet or mobile).

DevExpress Themes are based on Microsoft's themes and skins technology. You can use each of these themes easily, without modification or manipulate them with our free ASP.NET Theme Builder application.

Free TrialLearn About Themes

I call DevExpress development tools the wonders of software development in this present age and ages to come. The tools are so amazing and excellent ranging from the UI Presentation Components to Reporting Tools and business App Framework. Godwin Mathias
Elegant Web Themes - ASP.NET Spreadsheet Control | DevExpress

Start your free 30-day trial today!

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

 

Download Free Trial

Buy this product as part of the following subscription packages.

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.

Tag <dxtransform> is invalid. Transformation failed: An error occurred while loading document '../../../App_Data/GeneratedData/ProductsStructure.xml'. See InnerException for a complete description of the error.

* DevExpress does not include/ship source code for certain products, including CodeRush, TestCafe Studio, and Report & Dashboard Server.

Additional Info

Customizable ASP.NET Themes

The DevExpress ASP.NET Subscription ships with 20+ highly polished themes for your next web application. You can use each of these themes easily, without modification or manipulate them using our free ASP.NET Theme Builder application. See Demo

Sec 508 and Accessibility

The DevExpress ASP.NET Subscription makes it easy to create web applications that meet government regulations regarding web accessibility. Sec 508 and Web Content Accessibility Guidelines 1.0 support is available across our entire DevExpress ASP.NET Product Line. Read about accessibility

Touch and Mobile Device Enabled

Deliver elegant, touch-enabled ASP.NET and MVC web applications using the platform you know and love. The ASP.NET Subscription helps you leverage your current investments and address customer needs via a comprehensive range of Web Forms Controls and MVC Extensions that support touch on iOS Safari, Android and Internet Explorer 10.

AJAX Enabled with Rich Client-Side API

Each and every control provides an ability to update the control using callbacks, eliminating the need to re-load the entire page. This callback functionality allows you to optimize how data is transferred to the client. We also offer you a comprehensive client-side API, along with the ability to handle events on the client side. With our ASP.NET components, you have full control over the control's behavior via client functions.

Fast and Lightweight with XHTML Compliance

DevExpress controls are optimized for exceptional performance and efficient memory use without the loss of functionality or features. DevExpress ASP.NET controls also support optimizations like HTML compression, callbacks, image sprites, resource caching and sharing. Key ASP.NET controls in this subscription use semantic HTML to keep output clean and minimal. The semantic HTML markup means that web pages are lighter and faster, more search engine friendly and provide improved accessibility for screen readers.

Straightforward Localization

All DevExpress ASP.NET AJAX Controls can be easily localized using satellite resource assemblies. DevExpress delivers satellite assemblies for a large variety of languages and cultures. To make it easy to get started, resource files for three cultures are included to our installation: German, Japanese, and Spanish. If you need to modify our shipping resources or create satellite assemblies for a different language, simply use our Online Localization Service, a free tool for our active ASP.NET subscribers. Online Localization Service

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