public async Task <HttpResponseMessage> DownloadProductasExcel(int catalogId, int companyId)
{
var Product = await _catalogHelper.GetProductDetailsAsMemoryStream(companyId, catalogId);
//_workbook.SaveAs(memoryStream);
var response = new HttpResponseMessage(HttpStatusCode.OK)
{
Content = new ByteArrayContent(Product.Item1.ToArray())
};
response.Content.Headers.ContentType = new MediaTypeHeaderValue
("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
response.Content.Headers.ContentDisposition =
new ContentDispositionHeaderValue("attachment")
{
FileName = $"{Regex.Replace(Product.Item2, @"\s+", "")}_{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx"
};
return(response);
}
