public void WriteReportTest()
{
var destinationPath = $@"TestReportShort.xlsx";
U2ReportExcelWriter.WriteReport(u2Report, destinationPath);
Assert.IsTrue(File.Exists(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));
}
//https://zyght.blob.core.windows.net/acorde-demo/net5.0.zip
static void Main(string[] args)
{
var logRepository = LogManager.GetRepository(Assembly.GetEntryAssembly());
XmlConfigurator.Configure(logRepository, new FileInfo("log4net.config"));
Log.Info($"Start ------------------------");
Log.Info($"Argumentos pasados {args.Length}: {args}");
var reportArg = ArgumentHelper.GetArguments(args);
if (string.IsNullOrWhiteSpace(reportArg.Origin) || string.IsNullOrWhiteSpace(reportArg.Destination))
{
Log.Error("Debe ingresar Nombre del informe origina (ruta), Nombre del informe final en el Excel ");
return;
}
Log.Info($"Archivo origen: {reportArg.Origin}");
Log.Info($"Archivo destino: {reportArg.Destination}");
Log.Info($"Columnas numericas: {reportArg.MoneyColumns}");
try
{
var u2Report = ReportReader.Load(reportArg.Origin, reportArg.MoneyColumns);
Log.Info($"Lineas cargadas: {u2Report.Body.Count}");
U2ReportExcelWriter.WriteReport(u2Report, reportArg.Destination);
}
catch (Exception e)
{
Log.Error(e);
}
Log.Info($"END ------------------------");
}