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