THEMES
THEME SETTINGS

Spreadsheet Overview

  • Undo

    Undo
    po
  • Clipboard

    Clipboard
    po
  • v
    v
    popopopo
    Font

    Font
    po
  • Alignment

    Alignment
    po
  • po
    dialogboxlauncherNumber

    Number
    po
  • Cells

    Cells
    po
  • Editing

    Editing
    po
  • Styles

    Styles
    po
  • Show

    Show
    po
  • View

    View
    po
  • Window

    Window
    po
  • Table Name
    Properties

    Properties
    po
  • Tools

    Tools
    po
  • Table Style Options

    Table Style Optionspo
  • Table Style Options

    Table Style Optionspo
 
About the Spreadsheet

The new DevExpress ASP.NET MVC Spreadsheet is an Excel inspired extension that allows you to introduce spreadsheet functionality to any ASP.NET MVC application with ease. It provides a rich UI and comprehensive API to create, manage and convert spreadsheet files. Your application will not require Microsoft Excel to be installed on your computer, and those of your end-users, to accomplish these tasks.

The following code demonstrates how to add a spreadsheet to your web project and programmatically load an XLSX document to the spreadsheet.

View code:

@using(Html.BeginForm()) {
    @Html.Partial("OverviewPartial")
}

Partial View code:

@Html.DevExpress().Spreadsheet(
    settings => {
        settings.Name = "spreadsheet";
        settings.CallbackRouteValues = new { Controller = "Home", Action = "OverviewPartial" };
    }
).Open(Server.MapPath("~/App_Data/Documents/MonthlyBudget.xlsx")).GetHtml()

Controller code:

public class HomeController : Controller {
    public ActionResult Overview() {
        return View("Overview");
    }
    public ActionResult OverviewPartial() {
        return PartialView("OverviewPartial");
    }
}

Resources to Learn
Key Features
  • Microsoft Office Inspired UI
    The ASP.NET MVC Spreadsheet provides a UI experience similar to the one your end-users expect from today's most popular office productivity suite. It includes full integration with the DevExpress ASP.NET MVC Ribbon extension, so you can quickly deliver stunning applications.
  • Support for Popular File Formats
    With the DevExpress ASP.NET MVC Spreadsheet, you and your end-users can load, convert and save workbooks in popular spreadsheet file formats such as XLS, XLSX, XLSM, CSV and TXT.
  • Formula Calculation Engine
    Perform complex calculations using formulas with various functions and cell references, and create shared and array formulas. A comprehensive range of Microsoft Excel compatible functions is supported for use within formulas.
  • Integrated Charts
    A variety of chart types and built-in presets allow you to display data for your customers in a meaningful way. Also, our native chart engine can display charts so that their appearance is similar to the charts found in Microsoft Excel.
  • Pictures
    Insert, move, change, transform and delete pictures incorporated into a worksheet.
  • Mail Merge Support
    An integrated mail-merge engine allows you to programmatically create personalized letters, catalogs and a myriad of business reports that are only possible with the capabilities inherent in a spreadsheet.
Version: v2016 vol 2.4
Copyright © 2006-2017 Developer Express Inc
Your Next Great MVC App Starts Here

Get started today and download your 30-day trial of DevExpress MVC Extensions (includes 30 days of free technical support).

All demos ship with full source code and are included in the DevExpress MVC distribution. Refer to the Demos and Sample Applications topic to learn more.

DevExpress MVC Extensions ship as part of DevExpress Universal, DXperience and ASP.NET Subscriptions and are backed by a 60 day unconditional money-back guarantee.
To learn more and obtain pricing information, visit the Compare Features and Pricing webpage. For immediate assistance, contact us by Email at info@devexpress.com or by phone at +1 (818) 844-3383 between 7:30am and 4:30pm Pacific Time.