How to download an Excel file from Ajax call in ASP.NET Core?

using Syncfusion.XlsIO;

Imports Syncfusion.XlsIO

@{
    ViewBag.Title = "Excel";
}
 
<h2>Click the button to download an Excel document from AJAX call</h2>
 
<input type="button" onclick="exported()" value="Export" />
 
<script>
 
    function exported(e) {
        $.ajax({
            type: "POST",
            url: '@Url.Action("ExportExcel", "Home")', //call your controller and action
            contentType: "application/json; charset=utf-8",
            dataType: "json",
        }).done(function (data) {
 
            //get the file name for download
            if (data.fileName != "") {
                //use window.location.href for redirect to download action for download the file
                window.location.href = "@Url.RouteUrl(new { Controller = "Home", Action = "Download" })/?fileName=" + data.fileName;
            }
        });
    }
</script>

@Code
    ViewData("Title") = "Excel"
End Code
 
<h2>Click the button to download an Excel document from AJAX call</h2>
 
<input type="button" onclick="exported()" value="Export" />
 
<script>
 
    function exported(e) {
        $.ajax({
            type: "POST",
            url: '@Url.Action("ExportExcel", "Home")', //call your controller and action
            contentType: "application/json; charset=utf-8",
            dataType: "json",
        }).done(function (data) {
 
            //get the file name for download
            if (data.fileName != "") {
                //use window.location.href for redirect to download action for download the file
                window.location.href = "@Url.RouteUrl(New With {.Controller = "Home", .Action = "Download"})/?fileName=" + data.fileName;
            }
        });
    }
</script>

private readonly IHostingEnvironment _hostingEnvironment;
private string _fileName;
private string _filePath; 
 
public HomeController(IHostingEnvironment hostingEnvironment)
{
    _hostingEnvironment = hostingEnvironment;
    _fileName = "AjaxCall.xlsx";
    _filePath = string.Format("{0}/{1}", _hostingEnvironment.WebRootPath, _fileName);
}

[HttpPost]
public ActionResult ExportExcel()
{
    //Create an instance of ExcelEngine
    using (ExcelEngine excelEngine = new ExcelEngine())
    {
        //Set the default application version as Excel 2016
        excelEngine.Excel.DefaultVersion = ExcelVersion.Excel2016;
 
        //Create a workbook with a worksheet
        IWorkbook workbook = excelEngine.Excel.Workbooks.Create(1);
 
        //Access first worksheet from the workbook instance
        IWorksheet worksheet = workbook.Worksheets[0];
 
        //Insert sample text into cell “A1”
        worksheet.Range["A1"].Text = "Hello World!";
 
        //Save the workbook to disk in xlsx format
        workbook.Version = ExcelVersion.Excel2016;
        using (FileStream fileStream = new FileStream(_filePath, FileMode.Create, FileAccess.ReadWrite))
        {
            workbook.SaveAs(fileStream);
        }
    }
    var errorMessage = "you can return the errors here!";
    //Return the Excel file name
    return Json(new { _fileName, errorMessage });
}
 
[HttpGet]
public ActionResult Download(string fileName)
{
    byte[] fileByteArray = System.IO.File.ReadAllBytes(_filePath);
    System.IO.File.Delete(_filePath);
    return File(fileByteArray, "application/vnd.ms-excel", _fileName);
}

<HttpPost()>
Public Function ExportExcel() As ActionResult
    'Create an instance of ExcelEngine
    Dim excelEngine As ExcelEngine = New ExcelEngine
 
    'Set the default application version as Excel 2016
    excelEngine.Excel.DefaultVersion = ExcelVersion.Excel2016
 
    'Create a workbook with a worksheet
    Dim workbook As IWorkbook = excelEngine.Excel.Workbooks.Create(1)
 
    'Access first worksheet from the workbook instance
    Dim worksheet As IWorksheet = workbook.Worksheets(0)
 
    'Insert sample text into cell A1
    worksheet.Range("A1").Text = "Hello World!"
 
    'Save the workbook to disk in xlsx format
    workbook.Version = ExcelVersion.Excel2016
 
    Dim fileStream As FileStream = New FileStream(_filePath, FileMode.Create, FileAccess.ReadWrite)
    workbook.SaveAs(fileStream)
    Dim errorMessage = "you can return the errors here!"
 
    'Return the Excel file name
    Return Json(New Object() {_fileName, errorMessage})
End Function
 
<HttpGet()>
Public Function Download(ByVal fileName As String) As ActionResult
    Dim fileByteArray() As Byte = System.IO.File.ReadAllBytes(_filePath)
    System.IO.File.Delete(_filePath)
    Return File(fileByteArray, "application/vnd.ms-excel", _fileName)
End Function