private void btnOpenAndTransform_Click(object sender, EventArgs e)
{
try
{
btnOpenAndTransform.Enabled = false;
int initialRow;
int copyUntilMaxPlusRows;
Int32.TryParse(txtInitialRowNr.Text, out initialRow);
Int32.TryParse(txtCopyUntil.Text, out copyUntilMaxPlusRows);
initialRow = initialRow == 0 ? 1 : initialRow; // Default InitialRow = 1
copyUntilMaxPlusRows = copyUntilMaxPlusRows < 0 ? -1 : copyUntilMaxPlusRows; // Default copyUntilMaxPlusRows = -1
ExcelUpdater updater = new ExcelUpdater();
updater.ProcessExcelFile(txtFilePath.Text, initialRow, copyUntilMaxPlusRows);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
btnOpenAndTransform.Enabled = true;
}
}
private void button1_Click(object sender, EventArgs e)
{
int initialRow;
int copyUntilMaxPlusRows;
Int32.TryParse(txtInitialRowNr.Text, out initialRow);
Int32.TryParse(txtCopyUntil.Text, out copyUntilMaxPlusRows);
initialRow = initialRow == 0 ? 1 : initialRow; // Default InitialRow = 1
copyUntilMaxPlusRows = copyUntilMaxPlusRows < 0 ? -1 : copyUntilMaxPlusRows; // Default copyUntilMaxPlusRows = -1
ExcelUpdater updater = new ExcelUpdater();
updater.Play(txtFilePath.Text, initialRow, copyUntilMaxPlusRows);
}
