How do i export data to excel file in memory and download it

I am using EPPlus Library.

var myfile = HostingEnvironment.MapPath("~/DataFolder/MyExcelFile.xlsm");
var fileName = "MyExcelFile.xlsm";
var fileBytes = ExportExcel(myfile);
return File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, fileName);

private byte[] ExportExcel(string excelFile)
{
var ms = new MemoryStream();

DataTable dtNew = GetNewReport();
string xlReportSheet = ConfigurationManager.AppSettings["WorkSheetName_Report"];

DataTable dtDetails = GetDetails();
string xlDetailsSheet = ConfigurationManager.AppSettings["WorkSheetName_Details"];

using (ExcelPackage xlPackage = new ExcelPackage(ms))
{
if (dtNew.Rows.Count > 0)
{
ExportRecapDataNew(dtNew, xlReportSheet, xlPackage);
xlPackage.Save();
}

if (dtDetails.Rows.Count > 0)
{
ExportRecapDataRemodel(dtRemdl, xlDetailsSheet, xlPackage);

xlPackage.Save();
}
}

return ms.ToArray();
}

Hi Istudent Rana,

 

You can use Spire.XLS library (https://www.nuget.org/packages/Spire.XLS/) to accomplish this function. Refer to the following code.

 

Save Excel file to memory stream:

Load the file from memory stream, export data table to the file and then save it:

 

Thank you every one. 

 

This is how i did it.

 

var myfile = HostingEnvironment.MapPath("~/DataFolder/MyExcelFile.xlsm");
var fileName = "MyExcelFile.xlsm";
var fileBytes = ExportExcel(myfile);
return File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, fileName); 

In Which Langugaes you want to this. if in C# then you can try below code  -