# spreadsheet-editor-default

> Spreadsheet editor with formula, number formatting, row/column configuration, and styled header/footer rows.

**Framework:** aspnet-core  **Component:** Spreadsheet  **Variant:** default

## Get this item

**If you are an agent, fetch the JSON.** Source is inlined, so one request is enough and no tooling is required:

```
GET https://ai.syncfusion.com/r/aspnet-core/spreadsheet-editor-default.json
```

**Install Package(s)**

```bash
dotnet add package Syncfusion.AspNetCore.Spreadsheet
```

**Notes**

- Syncfusion release: 2026 Volume 3 (v35.1.37)
- The Syncfusion package is licensed. The composition in this file is source you own and edit. See https://ai.syncfusion.com/licensing.md

## Source files

### src/components/spreadsheet-editor-default/spreadsheet-editor.cshtml

```cshtml
@page
@namespace aspnet_core.SpreadsheetEditor.Default
@model EJ2CoreSampleBrowser.SpreadsheetEditor.Default.DefaultModel
@using Syncfusion.EJ2
@using Syncfusion.EJ2.Spreadsheet

    <div class="control-section">
        <ejs-spreadsheet id="spreadsheet" created="createdHandler">
            <e-spreadsheet-sheets>
                <e-spreadsheet-sheet name="Car Sales Report">
                    <e-spreadsheet-ranges>
                        <e-spreadsheet-range dataSource="@Model.DataSource"></e-spreadsheet-range>
                    </e-spreadsheet-ranges>
                    <e-spreadsheet-columns>
                        <e-spreadsheet-column width="180"></e-spreadsheet-column>
                        <e-spreadsheet-column width="130"></e-spreadsheet-column>
                        <e-spreadsheet-column width="130"></e-spreadsheet-column>
                        <e-spreadsheet-column width="180"></e-spreadsheet-column>
                        <e-spreadsheet-column width="130"></e-spreadsheet-column>
                        <e-spreadsheet-column width="120"></e-spreadsheet-column>
                    </e-spreadsheet-columns>
                </e-spreadsheet-sheet>
            </e-spreadsheet-sheets>
        </ejs-spreadsheet>
    </div>

    <script>
        // Bold the header row and format the amount column as currency.
        function createdHandler() {
            this.cellFormat({ fontWeight: 'bold', backgroundColor: '#279377', color: '#fff', textAlign: 'center' }, 'A1:F1');
            this.numberFormat('$#,##0.00', 'F2:F5');
        }
    </script>

```

### src/components/spreadsheet-editor-default/spreadsheet-editor.cshtml.cs

```cs
using System;
using System.Collections.Generic;
using Microsoft.AspNetCore.Mvc.RazorPages;

namespace EJ2CoreSampleBrowser.SpreadsheetEditor.Default
{
    public class DefaultModel : PageModel
    {
        public List<object> DataSource { get; set; }

        public void OnGet()
        {
            DataSource = new List<object>
            {
                new { Customer = "Customer A", Model = "Model A", Color = "Red",    PaymentMode = "Credit Card",  DeliveryDate = "01-15-2025", Amount = "1299.50" },
                new { Customer = "Customer B", Model = "Model B", Color = "Blue",   PaymentMode = "Net Banking", DeliveryDate = "02-08-2025", Amount = "2150.00" },
                new { Customer = "Customer C", Model = "Model C", Color = "Green",  PaymentMode = "Cash",         DeliveryDate = "03-22-2025", Amount = "875.75" },
                new { Customer = "Customer D", Model = "Model D", Color = "Yellow", PaymentMode = "Debit Card",  DeliveryDate = "04-11-2025", Amount = "1625.25" },
            };
        }
    }
}

```
