Spreadsheet - Overview

You can use the DevExpress ASP.NET Core Spreadsheet control to add spreadsheet functionality to an ASP.NET Core application. The control's key features: Microsoft Excel compatibility (XLS, XLSX, XLSM, CSV, TEXT), formula editing, data visualization (charts). You can configure each control with Razor C# or Razor VB syntax.

Backend API

@inject IWebHostEnvironment env @{ var documentPath = System.IO.Path.Combine( env.ContentRootPath, DirectoryManagmentUtils.GetDocumentSampleFolderPath(Context), "InvestmentPortfolio.xlsx"); } @(Html.DevExpress() .Spreadsheet("spreadsheet") .Height("500px") .Width("100%") .DocumentRequestHandlerUrl(Url.Action("DxDocumentRequest")) .Open(documentPath) )

using System; using System.IO; using System.Linq; using System.Text; using DevExpress.AspNetCore.Spreadsheet; using DevExpress.Spreadsheet; using DevExpress.XtraSpreadsheet.Export; using Microsoft.AspNetCore.Hosting; using Microsoft.AspNetCore.Mvc; namespace AspNetCoreDemos.Spreadsheet { [Route("[action]")] public class SpreadsheetController : Controller { public ActionResult Overview() { return View(); } public IActionResult DxDocumentRequest() { return SpreadsheetRequestProcessor.GetResponse(HttpContext); } } }