public IActionResult GetXls([FromQuery] int month, [FromQuery] int year)
{
try
{
byte[] xlsInBytes;
int offset = Convert.ToInt32(Request.Headers["x-timezone-offset"]);
var xls = _service.GenerateExcel(month, year, offset);
string filename = String.Format("Jurnal Penjualan Export - {0}.xlsx", DateTime.UtcNow.ToString("ddMMyyyy"));
xlsInBytes = xls.ToArray();
var file = File(xlsInBytes, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", filename);
return(file);
}
catch (Exception ex)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, ex.Message));
}
}
