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