public EpplusResult DonorTotalSummary(DonorTotalSummaryOptionsModel m) { var ep = new ExcelPackage(); var cn = new SqlConnection(Util.ConnectionString); var rd = cn.ExecuteReader("dbo.DonorTotalSummary", DonorTotalSummaryParameters(m, useMedianMin: true), commandType: CommandType.StoredProcedure, commandTimeout: 1200); ep.AddSheet(rd, "MemberNon"); rd = cn.ExecuteReader("dbo.DonorTotalSummaryBySize", DonorTotalSummaryParameters(m), commandType: CommandType.StoredProcedure, commandTimeout: 1200); ep.AddSheet(rd, "BySize"); rd = cn.ExecuteReader("dbo.DonorTotalSummaryByAge", DonorTotalSummaryParameters(m), commandType: CommandType.StoredProcedure, commandTimeout: 1200); ep.AddSheet(rd, "ByAge"); return new EpplusResult(ep, "DonorTotalSummary.xlsx"); }
public static byte[] ToExcelBytes(this IDataReader rd, string filename = null, bool useTable = false) { var dt = new DataTable(); dt.Load(rd); var ep = new ExcelPackage(); ep.AddSheet(dt, filename, useTable); return ep.GetAsByteArray(); }
public EpplusResult PledgeFulfillment2(int fundid1, int fundid2) { var ep = new ExcelPackage(); var cn = new SqlConnection(Util.ConnectionString); cn.Open(); var rd = cn.ExecuteReader("dbo.PledgeFulfillment2", new { fundid1, fundid2, }, commandTimeout: 1200, commandType: CommandType.StoredProcedure); ep.AddSheet(rd, "Pledges"); return new EpplusResult(ep, "PledgeFulfillment2.xlsx"); }
public static EpplusResult ToExcel(this DataTable dt, string filename = "People.xlsx", bool useTable = false) { var ep = new ExcelPackage(); ep.AddSheet(dt, filename, useTable); return new EpplusResult(ep, filename); }