How to download excel from Ajax call in ASP.NET MVC?

using Syncfusion.XlsIO;

Imports Syncfusion.XlsIO

@{
    ViewBag.Title = "View";
}
 
<h2>View</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") = "View"
End Code
 
<h2>View</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>

[HttpPost]
public ActionResult ExportExcel()
{
    var fileName = "AjaxCall" + ".xlsx";
 
    //Save the file to server temp folder
    string fullPath = Path.Combine(Server.MapPath("~/temp"), fileName);
 
    //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;
        workbook.SaveAs(fullPath);
    }
    var errorMessage = "you can return the errors here!";
    //Return the Excel file name
    return Json(new { fileName = fileName, errorMessage });
}
 
[HttpGet]
public ActionResult Download(string fileName)
{
    //Get the temp folder and file path in server
    string fullPath = Path.Combine(Server.MapPath("~/temp"), fileName);
    byte[] fileByteArray = System.IO.File.ReadAllBytes(fullPath);
    System.IO.File.Delete(fullPath);
    return File(fileByteArray, "application/vnd.ms-excel", fileName);
}

Function ExportExcel() As ActionResult
    Dim fileName = "AjaxCall" & ".xlsx"
 
    'Save the file to server temp folder
    Dim fullPath As String = Path.Combine(Server.MapPath("~/temp"), fileName)
 
    'Create an instance of ExcelEngine
    Using 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
        workbook.SaveAs(fullPath)
    End Using
    Dim errorMessage = "you can return the errors here!"
    'Return the Excel file name
    Return Json(New With {Key .fileName = fileName, errorMessage})
End Function
Function Download(ByVal fileName As String) As ActionResult
    'Get the temp folder and file path in server
    Dim fullPath As String = Path.Combine(Server.MapPath("~/temp"), fileName)
    Dim fileByteArray As Byte() = System.IO.File.ReadAllBytes(fullPath)
    System.IO.File.Delete(fullPath)
    Return File(fileByteArray, "application/vnd.ms-excel", fileName)
End Function