public IActionResult ConvertJsonArrayToExcel([FromBody] JArray jsonArray, string bpmnModelName, string guid, string userName)
{
try
{
byte[] fileContents;
using (var excelPackage = new ExcelPackage())
{
var excelWorksheet = excelPackage.Workbook.Worksheets.Add(bpmnModelName);
ExcelConverter.AddWorksheetInfo(ref excelWorksheet, userName, guid);
var excelTable = ExcelConverter.AddTableToWorkSheet(ref excelWorksheet, jsonArray, "TableName");
ExcelConverter.AddHeadersToExcelTable(excelTable, jsonArray);
ExcelConverter.AddDataToTabel(ref excelWorksheet, excelTable, jsonArray);
// export it to byte array.
fileContents = excelPackage.GetAsByteArray();
}
if (fileContents == null || fileContents.Length == 0)
{
return(NotFound());
}
//https://stackoverflow.com/a/50259742
return(File(
fileContents: fileContents,
contentType: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
fileDownloadName: $"{bpmnModelName}_test.xlsx"
));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}