private void RunButton_Click(object sender, EventArgs e)
{
try
{
string vFilename = "1.Control Consecutivos de Cartas.xlsx";
string vFilePath = DEFAULT_ATTACHMENTS_FOLDER + vFilename;
XlsHelper XlsHelper = new XlsHelper();
XlsHelper.InitializeExcel(vFilePath);
string SheetName = DateTime.Now.ToString("yyyy");
string vNumeroCartaPromesaPago = string.Empty;
string vClienteCartaPromesaPago = string.Empty;
int vRowNumber = 0;
do
{
vRowNumber++;
vClienteCartaPromesaPago = XlsHelper.GetValueFromColAndRow(vRowNumber, 2, SheetName);
}while (!string.IsNullOrWhiteSpace(vClienteCartaPromesaPago));
vNumeroCartaPromesaPago = XlsHelper.GetValueFromColAndRow(vRowNumber, 1, SheetName);
XlsHelper.SetValueFromColAndRow(vRowNumber, 2, "Tito Miguel", SheetName);
XlsHelper.SetValueFromColAndRow(vRowNumber, 3, "Carta Promesa", SheetName);
XlsHelper.SetValueFromColAndRow(vRowNumber, 4, "Principal", SheetName);
XlsHelper.SetValueFromColAndRow(vRowNumber, 5, DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss"), SheetName);
XlsHelper.SetValueFromColAndRow(vRowNumber, 6, "Lian Ríos", SheetName);
XlsHelper.SaveExcelFile(vFilePath);
XlsHelper.CloseExcel();
string vResultMessage = string.Format(
"Se guardaron los cambios en el archivo: {0}\n\r" +
"El contenido de la celda [{1}, 1] es: {2}",
vFilePath,
vRowNumber,
vNumeroCartaPromesaPago
);
MessageBox.Show(vResultMessage, "Resultado", MessageBoxButtons.OK);
}
catch (Exception vE)
{
logger.Error(vE);
MessageBox.Show(vE.GetExceptionMessage(), "Error", MessageBoxButtons.OK);
}
finally
{
this.Close();
}
}
public string WriteToFile(String fileName, HSSFWorkbook workbook)
{
return(XlsHelper.WriteToFile(fileName, workbook));
}
public string WriteToFile(HSSFWorkbook workbook)
{
return(XlsHelper.WriteToFile(workbook));
}
public void WriteToClient(String fileName, HSSFWorkbook workbook)
{
XlsHelper.WriteToClient(fileName, workbook);
}
