DevExpress.AspNetCore.Spreadsheet NuGet Package

The DevExpress ASP.NET Core Spreadsheet allows you to add spreadsheet functionality to an ASP.NET Core application. Generate a new document or load an existing file, and give users access to comprehensive workbook editing capabilities.

Key Features

• Microsoft Excel compatibility (XLS/XLSX/XLSM)
• Over 400 built-in formulas
• Data editing and input validation
• Data sorting and filtering support
• Document management API
• 2D and 3D Chart integration
• Ribbon and Context Menu customization
• Export to PDF/HTML

Examples

Install the DevExpress.AspNetCore.Spreadsheet NuGet package:

dotnet add package DevExpress.AspNetCore.Spreadsheet

Once installed, configure your application as described in the following help topic: Configure a Visual Studio Project.

Example 1: Add a Spreadsheet to a Page

Razor:

@inject Microsoft.AspNetCore.Antiforgery.IAntiforgery Antiforgery

<script>
    function spreadsheet_beforeSend(spreadsheet, e) {
        e.request.setRequestHeader("RequestVerificationToken",
                                    "@Antiforgery.GetAndStoreTokens(Context).RequestToken");
    }
</script>

@(Html.DevExpress().Spreadsheet("spreadsheet")
    .Height("500px")
    .Width("100%")
    .DocumentRequestHandlerUrl(Url.Page(pageName: null, pageHandler: "DxSpreadsheetRequest"))
    .ClientSideEvents(events =>
        events.OnBeforeSend("spreadsheet_beforeSend")
    )
)

Model:

public class SpreadsheetModel : Microsoft.AspNetCore.Mvc.RazorPages.PageModel {
    public IActionResult OnGetDxSpreadsheetRequest() {
        return SpreadsheetRequestProcessor.GetResponse(HttpContext);
    }
    public IActionResult OnPostDxSpreadsheetRequest() {
        return SpreadsheetRequestProcessor.GetResponse(HttpContext);
    }
}

Example 2: Activate the Auto-Save Feature

@(Html.DevExpress().Spreadsheet("spreadsheet")
    // ...
    .AutoSaveMode(DevExpress.Web.Office.AutoSaveMode.On)
    .AutoSaveTimeout(TimeSpan.FromMinutes(3))
)

Additional Examples on GitHub

• ASP.NET Core Spreadsheet - Use AJAX requests to update document content

Demos

• ASP.NET Core Spreadsheet - Overview

Related Components/Packages

DevExpress.AspNetCore.Dashboard - DevExpress ASP.NET Core Dashboard control.

dotnet add package DevExpress.AspNetCore.Dashboard

DevExpress.AspNetCore.Reporting - DevExpress ASP.NET Core Reporting control.

dotnet add package DevExpress.AspNetCore.Reporting

DevExpress.AspNetCore.RichEdit - DevExpress ASP.NET Core Rich Text Editor component.

dotnet add package DevExpress.AspNetCore.RichEdit

Documentation

• DevExpress ASP.NET Core Spreadsheet

Evaluation Period, Pricing Options, and Licensing Terms

Whether you own a license or want to start a 30-day evaluation period, download and register your DevExpress license key. To obtain your key, log in to the DevExpress Download Manager. Use your existing DevExpress.com account or create a new account for free. For key registration instructions, see License Key for DevExpress Products.

If you purchase a license after evaluating a product, re-register your updated DevExpress license key to remove evaluation version warnings/messages.

This package is included in the following commercial subscriptions:

• DevExpress ASP.NET and Blazor Subscription
• DevExpress DXperience Subscription
• DevExpress Universal Subscription

See DevExpress Subscriptions & Licensing for subscription comparison tables, purchasing FAQ, and licensing information.

Software Bill of Materials (SBOM)

To access SBOM files for DevExpress packages, please refer to the following article: Software Bill of Materials (SBOM) for DevExpress .NET assemblies/NuGet packages, JavaScript, VCL and other redistributable artifacts.

See Also: Information Security | Security - What You Need to Know

Useful Online Resources

• www.devexpress.com
• DevExpress Support Center
• DevExpress Blogs