public void Should_Generate_excel_with_custom_headers()
{
//Arrange
var list = _list;
var headers = new List <string>
{
"ID",
"Nume"
};
var filePath = Path.Combine(Directory.GetCurrentDirectory(), "excel2.xlsx");
var exporter = new ExcelDataExport <Customer>();
//Act
var stream = exporter.Export(list, new Dictionary <string, string>(), headers);
using (var fileStream = File.Create(filePath))
{
stream.Seek(0, SeekOrigin.Begin);
stream.CopyTo(fileStream);
}
var fileExistsAndNotEmpty = File.Exists(filePath) && new FileInfo(filePath).Length > 0;
if (File.Exists(filePath))
{
File.Delete(filePath);
}
//Assert
stream.Should().NotBeNull();
stream.Length.Should().BeGreaterThan(0);
fileExistsAndNotEmpty.Should().BeTrue();
}
public void Should_Generate_excel_from_object_list()
{
var numberOfElements = 10;
var exportDataList = new List <List <object> >();
for (var i = 0; i < numberOfElements; i++)
{
var list = new List <object>();
var id = i;
var name = "Customer " + i;
list.Add(id);
list.Add(name);
exportDataList.Add(list);
}
var headers = new List <string>
{
"ID",
"Nume"
};
var types = new List <string>
{
"int",
"string"
};
var filePath = Path.Combine(Directory.GetCurrentDirectory(), "excel3.xlsx");
var exporter = new ExcelDataExport <Customer>();
//Act
var stream = exporter.ExportFromListOfObjects(exportDataList, types, headers);
using (var fileStream = File.Create(filePath))
{
stream.Seek(0, SeekOrigin.Begin);
stream.CopyTo(fileStream);
}
var fileExistsAndNotEmpty = File.Exists(filePath) && new FileInfo(filePath).Length > 0;
if (File.Exists(filePath))
{
File.Delete(filePath);
}
//Assert
stream.Should().NotBeNull();
stream.Length.Should().BeGreaterThan(0);
fileExistsAndNotEmpty.Should().BeTrue();
}
protected void btnView_Click(object sender, ImageClickEventArgs e)
{
//MemoryStream oStream;
if (ViewState["sFromDT"].ToString() == "")
{
ViewState["sFromDT"] = "1900/01/01";
}
if (ViewState["sToDT"].ToString() == "")
{
ViewState["sToDT"] = "1900/01/01";
}
//ReportDocument reportDocumentObj = new ReportDocument();
//reportDocumentObj.Load(Server.MapPath("~/operations/CR_VoyageReport.rpt"));
DataTable dtreport = BLL_OPS_VoyageReports.Get_VoyageReport(ViewState["sReportType"].ToString(), Convert.ToInt32(ViewState["iVesselID"].ToString()), Convert.ToInt32(ViewState["iLocationID"].ToString()), ViewState["sFromDT"].ToString(), ViewState["sToDT"].ToString(), Convert.ToInt32(ViewState["iFleetID"].ToString()));
ExcelDataExport objexp = new ExcelDataExport();
objexp.WriteExcell(dtreport);
//reportDocumentObj.SetDataSource(dtreport);
//Response.Clear();
//Response.Buffer = true;
//oStream = (MemoryStream)reportDocumentObj.ExportToStream(ExportFormatType.Excel);
//Response.ContentType = "application/vnd.ms-excel";
//Response.BinaryWrite(oStream.ToArray());
//Response.End();
//ResponseHelper.Redirect("CR_VoyageReportView.aspx?REPORTTYPE=" + ViewState["sReportType"].ToString() + "&VESSELID=" + ViewState["iVesselID"].ToString() + "&LOCATIONCODE=" + ViewState["iLocationID"].ToString() + "&FROMDT=" + ViewState["sFromDT"].ToString() + "&TODT=" + ViewState["sToDT"].ToString() + "&FLEETID=" + ViewState["iFleetID"].ToString(), "blank", "");
// GridViewExportUtil.Export("NADReport"+DateTime.Now.ToShortDateString()+".xls", gvVoyageReport);
}
