static void CreateExcel()
{
string type = "";
OracleRepository rep = new OracleRepository();
MemoryStream stream =(MemoryStream) rep.LoadListingDocument("701", out type);
Cresa.Services.Excel.ExcelReader reader = new Services.Excel.ExcelReader();
var template = reader.ReadExcel(stream);
var srv = new Cresa.Services.Excel.ListingExcelService("");
var excelBytes = srv.Export(template, "48013");
File.WriteAllBytes(@"D:\CurrentDevelopment\Cresa\out.xlsx", excelBytes);
}
public ActionResult ExportListing(string id)
{
string type = "";
OracleRepository rep = new OracleRepository();
MemoryStream stream = (MemoryStream)rep.LoadListingDocument("701", out type);
Cresa.Services.Excel.ExcelReader reader = new Services.Excel.ExcelReader();
var template = reader.ReadExcel(stream);
var srv = new Cresa.Services.Excel.ListingExcelService("");
var excelBytes = srv.Export(template, id);
Response.AddHeader("Content-Disposition","attachment; filename=Cresa - Industrial Market Availabilities.xlsx");
return new FileContentResult(excelBytes,
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
}