public void Test_Excel_FileExport() { IFileExporter <DataTable> exporter = new ExcelDataTableFileExporter(); var dt = new DataTable() { Columns = new [] { "Column1", "Column2", "Column3" }, Rows = new DataRow[] { new DataRow() { Values = new [] { "1", "2", "3" } }, new DataRow() { Values = new [] { "4", "5", "6" } } } }; var outStream = exporter.Export(dt); outStream.Position = 0; using (FileStream outFileStream = new FileStream("C:\\Tests\\test.xlsx", FileMode.Create)) { outStream.CopyTo(outFileStream); } }
public JsonResult Export(string name, DataTable data) { IFileExporter <DataTable> exporter = new ExcelDataTableFileExporter(); var fileStream = exporter.Export(data); fileStream.Position = 0; var ms = new MemoryStream(); fileStream.CopyTo(ms); ms.Position = 0; string fileGUID = Guid.NewGuid().ToString(); Session[fileGUID] = ms.ToArray(); string fileName = String.Format("{0}_{1}", name, fileGUID); return(Json(new { FileGUID = fileGUID, FileName = fileName })); }