Syncfusion.EJ2.Spreadsheet.AspNet.Core 19.4.0.54
View.cshtml
@(Html.EJS().Spreadsheet("sheet")
.OpenUrl("OpenExcel")
.SaveUrl("SaveExcel")
.Render())
Controller
#region
Excel
public IActionResult Excel ()
{
return View();
}
public IActionResult OpenExcel(IFormCollection openRequest)
{
OpenRequest open = new OpenRequest();
if (openRequest.Files.Count != 0)
{
open.File = openRequest.Files[0];
}
open.Password = openRequest["Password"];
if (openRequest["SheetIndex"].Count != 0)
{
open.SheetIndex = int.Parse(openRequest["SheetIndex"]);
}
open.SheetPassword = openRequest["SheetPassword"];
return Content(Workbook.Open(open));
}
public IActionResult SaveExcel(SaveSettings saveSettings)
{
return Workbook.Save(saveSettings);
}
#endregion
