Having trouble getting help?
Contact Support
Contact Support
Changing the active sheet in Spreadsheet control
30 Dec 20241 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.
<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>
public IActionResult Open(IFormCollection openRequest)
{
OpenRequest open = new OpenRequest();
open.File = openRequest.Files[0];
return Content(Workbook.Open(open));
}