Changing the active sheet in ASP.NET Core Spreadsheet control

28 Oct 20251 minute to read

You can change the active sheet of imported file by updating activeSheetIndex property on the openComplete event.

The following code example shows how to set the active sheet when importing an Excel file.

CSHTML

<ejs-spreadsheet id="spreadsheet" openUrl="Open" openComplete="openComplete">

</ejs-spreadsheet>

<script>

    function openComplete(args) {
        var spreadsheetObj = ej.base.getComponent(document.getElementById('spreadsheet'), 'spreadsheet');
        if (spreadsheetObj) {
            spreadsheetObj.activeSheetIndex = 2;
        }
    }

</script>

OpenController.cs

public IActionResult Open(IFormCollection openRequest)
{
    OpenRequest open = new OpenRequest();
    open.File = openRequest.Files[0];
    return Content(Workbook.Open(open));
}