Example #1
0
        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();
        }
Example #2
0
        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;
            }
        }