private void CreateReportData(ReportGeneralModel model, Excel xls) { int rowIndexResume = 2; int writeRowIndex = 6; int i = 1; using (DataSet ds = this.db.REPORT_GeneralDetalle(model.ClientID, model.DateStart, model.DateEnd, model.Folder, model.Record)) { XSSFRow x = xls.NewRow(rowIndexResume); this.CreateReportResumeRow(x, ds.Tables["Resumen"].Rows[0]); foreach (DataRow row in ds.Tables["Detalle"].Rows) { XSSFRow y = xls.NewRow(writeRowIndex); this.CreateReportDataRow(y, row, i); writeRowIndex++; i++; } } }
private FileContentResult CreateReport(ReportGeneralModel model) { string path = Server.MapPath(ConfigurationManager.AppSettings["Excel.Template"]); string fileName = String.Format("[{0}] Reporte.xlsx", DateTime.Now.ToString("yyyy-MM-dd")); using (Excel xls = new Excel(path)) { this.CreateReportData(model, xls); MemoryStream ms = new MemoryStream(); xls._Workbook.Write(ms); return File(ms.ToArray(), "application/vnd.ms-excel", fileName); } }