HomeController.cs

using DevExpress.Spreadsheet;
using DevExpress.Web.Mvc;
using System;
using System.Collections.Generic;
using System.Drawing;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace DXWebApplication1.Controllers
{
    public class HomeController : Controller
    {
        public ActionResult Index()
        {
            return View();
        }

        public ActionResult SpreadsheetPartial() {
            return PartialView("_SpreadsheetPartial");
        }

        public ActionResult CustomAction(string customCommand) {
            IWorkbook workbook = SpreadsheetExtension.GetCurrentDocument("Spreadsheet");
            Worksheet worksheet = workbook.Worksheets[0];
           
            switch (customCommand) {
                case "applyFormatting":
                    CellRange priceRange = worksheet.Range["C2:C15"];
                    Formatting rangeFormatting = priceRange.BeginUpdateFormatting();
                    rangeFormatting.Font.Color = Color.SandyBrown;
                    rangeFormatting.Font.FontStyle = SpreadsheetFontStyle.Bold;
                    rangeFormatting.Fill.BackgroundColor = Color.PaleGoldenrod;
                    rangeFormatting.NumberFormat = "$0.0#";

                    rangeFormatting.Alignment.Vertical = SpreadsheetVerticalAlignment.Center;
                    rangeFormatting.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center;
                    priceRange.EndUpdateFormatting(rangeFormatting);
                    break;
                case "insertLink":
                    worksheet.Columns["G"].WidthInPixels = 180;
                    Cell cell1 = worksheet.Cells["G4"];
                    cell1.Fill.BackgroundColor = Color.WhiteSmoke;
                    worksheet.Hyperlinks.Add(cell1, "https://documentation.devexpress.com/OfficeFileAPI/14912/Spreadsheet-Document-API", true, "Spreadsheet Document API");
                    break;
                case "drawBorders":
                    CellRange tableRange = worksheet.Range["A2:E16"];
                    tableRange.Borders.SetAllBorders(Color.RosyBrown, BorderLineStyle.Hair);
                    break;
                case "showTotal":
                    Cell cell2 = worksheet.Cells["E16"];
                    cell2.Formula = "=SUBTOTAL(9,E2:E15)";
                    Cell cell3 = worksheet.Cells["A16"];
                    cell3.Formula = "SUBTOTAL(103,A2:A15)";
                    Cell cell4 = worksheet.Cells["D16"];
                    cell4.Value = "Total amount";
                    break;
            }
            return SpreadsheetExtension.GetCustomActionResult("Spreadsheet");

        }
    }
}