Open and Save in Blazor Spreadsheet component

26 Jun 20252 minutes to read

The Open and Save options in the Spreadsheet component enable efficient management of Excel files. These functionalities support opening existing Excel files for analysis and modification, as well as saving updates or new files to the system in compatible formats.

Open

The Spreadsheet component can open an Excel document along with its data, styles, formats, and more.

Open an Excel file via the UI

To open an Excel document using the interface, select the File > Open option from the ribbon menu.

Open an Excel file from a local path

The Syncfusion Blazor Spreadsheet component enables loading Excel files directly by converting them into byte arrays. This method is particularly effective for dynamically loading Spreadsheet content from a backend service.

Index.razor

@using Syncfusion.Blazor.Spreadsheet

<SfSpreadsheet DataSource="DataSourceBytes" >
    <SpreadsheetRibbon></SpreadsheetRibbon>
</SfSpreadsheet>

@code {
    public byte[] DataSourceBytes { get; set; }

    protected override void OnInitialized()
    {
        string filePath = "wwwroot/Sample.xlsx";
        DataSourceBytes = File.ReadAllBytes(filePath);
    }
}

Open an Excel file from Base64 string data

Excel files can also be loaded by passing a Base64-encoded representation of the file. This approach is effective for dynamically loading content from a database or API without exposing the file path.

Index.razor

@using Syncfusion.Blazor.Spreadsheet

 <SfSpreadsheet DataSource="DataSourceBytes" >
    <SpreadsheetRibbon></SpreadsheetRibbon>
 </SfSpreadsheet>

@code {
    public byte[] DataSourceBytes { get; set; }

    protected override void OnInitialized()
    {
        string base64String = "Enter the base64 string data here";
        DataSourceBytes = Convert.FromBase64String(base64String);     
    }
}

Supported file formats

The following format is supported for opening:

• MS Excel (.xlsx)
• MS Excel 97-2003 (.xls)

Save

The Spreadsheet component can save data, styles, formatting, and additional content as an Excel file.

Save an Excel file using UI

To save the Spreadsheet content through the user interface, select the File > Save As option from the ribbon menu.

Supported file formats

The following format is supported for saving:

• MS Excel (.xlsx)