public void CreateExcelFileTest()
{
const string filename = "SimpleBook2.xlsx";
var target = new GenericWriteExcel();
var rows = SimpleExcelRowFactory.CreateSimpleRows();
var actual = target.CreateExcelFile(rows);
using (var file = File.OpenWrite(filename))
{
file.Write(actual.GetBuffer(), 0, (int) actual.Length);
}
using (var file = File.OpenRead(filename))
{
var excel = new GenericReadExcel {HasHeader = true};
var actualRows = excel.ExtractRows(file, (header, row) => new SimpleExcelRow
{
Col1 = row.GetValue<int>(1),
Col2 = row.GetValue<string>(2),
Col3 = row.GetValue<DateTime>(3)
}, 1);
var actualRowsList = new List<SimpleExcelRow>();
actualRowsList.AddRange(actualRows);
AssertEx.PropertyValuesAreEquals(actualRowsList, rows);
}
}
private ActionResult ExportSearch <T>(IEnumerable <T> result, string type) where T : class
{
var timestamp = DateTime.Now.ToString(".dd.MM.yyyy.HH.mm.ss");
var excel = new GenericWriteExcel();
var excelFile = excel.CreateExcelFile(result);
var fileName = type + timestamp + ".xlsx";
// contruct the path
var filePath = Path.Combine(Settings.Default.SearchExportFolder, fileName);
// save the file
using (var file = System.IO.File.Create(filePath))
{
excelFile.Seek(0, SeekOrigin.Begin);
excelFile.CopyTo(file);
}
// serve the reponse
return(this.Json(new { File = timestamp, Type = type, Status = "OK" }));
}