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"); }