private static void WriteBody(SLDocument sl, U2Report u2Report) { var rowStart = u2Report.Headers.Count + 2; for (var rowIndex = 1; rowIndex < u2Report.Body.Count; rowIndex++) { var rowContent = ReportReader.GetBodyCells(u2Report.Body[rowIndex]); for (var columnIndex = 1; columnIndex < rowContent.Count; columnIndex++) { var content = rowContent[columnIndex - 1]; var rowPosition = rowStart + rowIndex; if (u2Report.IsMoneyColumn(columnIndex)) { PrintMoneyCell(sl, rowPosition, columnIndex, content); } else { sl.SetCellValue(rowPosition, columnIndex, content); if (rowIndex % 2 == 0) { sl.SetCellStyle(rowPosition, columnIndex, U2ReportStyles.GetStripStyle(sl)); } } } } }
public void SetUp() { var columns = "Debitos:Saldo:Creditos:Base"; u2Report = ReportReader.Load( @"C:\Users\zyghtadmin\source\repos\U2ToExcel\U2ToExcel\Resources\CP0220RU2.csv", columns); }
public static void WriteReport(U2Report u2Report, string destinationPath) { var sl = new SLDocument(); WriteHeader(sl, u2Report); SetupColumnsFilter(sl, u2Report); WriteBody(sl, u2Report); sl.SaveAs(destinationPath); }
public void WriteWalletTest() { var columns = "Plazo:Dias-V:Corriente:V 1-30:V 31-60:V 61-90:V 91-120:V 121-180:V 181-360:V 360-mas:TOTAL "; u2Report = ReportReader.Load($"{resourcesPath}CARTERA-U2.csv", columns); var destinationPath = $@"Catera.xlsx"; U2ReportExcelWriter.WriteReport(u2Report, destinationPath); Assert.IsTrue(File.Exists(destinationPath)); }
private static void WriteHeader(SLDocument sl, U2Report u2Report) { var style = sl.CreateStyle(); style.Font.Bold = true; var cellCounter = 1; foreach (var line in u2Report.Headers) { var cellRef = $"A{cellCounter}"; sl.SetCellValue(cellRef, line); sl.SetCellStyle(cellRef, style); cellCounter++; } }
private static void SetupColumnsFilter(SLDocument sl, U2Report u2Report) { var rowStart = u2Report.Headers.Count + 2; var cellsContent = ReportReader.GetBodyCells(u2Report.Body[0]); var columnCounter = 1; foreach (var line in cellsContent) { sl.SetCellValue(rowStart, columnCounter, line); sl.SetCellStyle(rowStart, columnCounter, U2ReportStyles.GetColumnsFilterStyle(sl)); sl.SetColumnWidth(columnCounter, U2ReportStyles.ColumnWidth); columnCounter++; } var cellRef = $"A{rowStart}"; var cellRefEnd = $"XX{rowStart}"; sl.Filter(cellRef, cellRefEnd); }
public void SetUp() { u2Report = ReportReader.Load( @"C:\Users\zyghtadmin\source\repos\U2ToExcel\U2ToExcel\Resources\REP-ORIGINAL-Short.csv"); }