private void cmbSheets_SelectedValueChanged(object sender, EventArgs e) { int i = Convert.ToInt32(cmbSheets.SelectedValue); Office.ExcelSheet sh = OpenedExcelFile.Sheets.FirstOrDefault(a => a.Index == i); lblNumberOfColumns.Text = $"Столбцов: {sh.LastCell.Column}"; lblNumberOfRows.Text = $"Строк: {sh.LastCell.Row}"; cmbLinks.DataSource = ExcelStatic.GetColumnNames(sh.LastCell.Column); cmbNames.DataSource = ExcelStatic.GetColumnNames(sh.LastCell.Column); txtBeginRow.Text = "2"; txtEndRow.Text = sh.LastCell.Row.ToString(); }
private void btnOpenFile_Click(object sender, EventArgs e) { if (this.BWorker != null && BWorker.IsBusy) { MessageBox.Show("Дождитесь завершения операции.", "Программа в процессе..", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } string path = ExcelStatic.OpenExcelFileDialog(); if (!string.IsNullOrEmpty(path)) { ReadExcelFileInfo(path); } else { OpenedExcelFile = null; } }