Exemple #1
0
        /// <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}");
        }
Exemple #2
0
        /// <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}");
        }