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