Create Excel with Ajax in Razorpages with Handler-Method creates a corrupt File
Hi
I am trying to create an Excel file after an Ajax post.
I use the Hander method with Razor pages.
The file is created server side. After that the file should be opened as stream as ajax result. I don't want to write the file to the filesystem.
I used this example as a template and converted it to the handler method.
https://ej2.syncfusion.com/aspnetcore/Excel/Create
In this example, the file is also automatically opened with the correct content type, and no javascript is required to open the file.
In my example the file is not opened automatically and I have to open it with javascript, which I don't like either.
The opened file is then corrupt.
I have tried quite a few hours and many examples. Unfortunately I did not reach the goal.
Thanks for the help
Reto
View
@page "{handler?}"
@model Razor_SyncMix.Pages.ExcelModel
@using Syncfusion.EJ2
@{
ViewData["Title"] = "Excel";
}
<input id="createbtn" class="btn btn-primary e-btn" type="button" onclick="createExcel()" name="button" value="Create Document" style="width:160px; text-transform:capitalize" />
<script>
// create Excel
createExcel = function() {
let ajax = new ej.base.Ajax({
url: "?handler=Create", processData: false, dataType: "Application/vnd.ms-excel", type: "POST"
});
ajax.send().then();
ajax.onError = function(data) {
alert("Error: handler=Excel")
}
ajax.onSuccess = function(data) {
var blob = new Blob([data], { type: "Application/vnd.ms-excel" })
var url = window.URL.createObjectURL(blob);
var a = document.createElement("a");
document.body.appendChild(a);
a.rel='nofollow' href = url;
a.click();
};
}
</script>Controller
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
using Syncfusion.XlsIO;
namespace ExcelTest.Pages
{
[IgnoreAntiforgeryToken] // Ajax Post
public class ExcelModel : PageModel
{
public ActionResult OnPostCreate(string SaveOption)
{
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
// Workbench
IWorkbook workbook = application.Workbooks.Create(1);
workbook.Worksheets[0]["A1"].Text = "Ajax Call";
//Set the version of the workbook
//workbook.Version = ExcelVersion.Excel2013;
var ContentType = "Application/msexcel";
//Save the workbook to stream
MemoryStream outputStream = new MemoryStream();
workbook.SaveAs(outputStream);
outputStream.Position = 0;
var fileName = "text.xls";
return File(outputStream, ContentType, fileName);
}
}
}
