/// <summary>
/// Get last row and last column for a worksheet.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
ExcelUsed eu = new ExcelUsed();
ExcelLast results = eu.UsedRowsColumns(fileName, sheetName);
MessageBox.Show($"row {results.Row} col {results.Column}");
}
/// <summary>
/// Get last row and last column for a worksheet.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
ExcelUsed eu = new ExcelUsed();
ExcelLast results = eu.UsedRowsColumns(fileName, sheetName);
// send results to Visual Studio Output window
Console.WriteLine($"{results.Row} {results.Column}");
}