private void FillColumns(ExcelFileItem sourceItem) { var columns = ExcelHelper.GetColumnsNames(sourceItem.FilePath, cmbSheetName.Text).ToList(); if (columns == null) return; excelColnfoBindingSource.DataSource = columns.ToList(); }
private void btnSelectDest_Click(object sender, EventArgs e) { DialogResult result = openFileDialog1.ShowDialog(); if (result != DialogResult.OK) return; destinationItem = new ExcelFileItem() { FilePath = openFileDialog1.FileName }; destItemBindingSource.DataSource = destinationItem; txtDestFile.Text = destinationItem.FilePath; FillDestinationSheets(txtDestFile.Text); }
private void FillSheets(ExcelFileItem sourceItem) { cmbSheetName.Items.Clear(); var sheetsList = ExcelHelper.GetSheetsName(sourceItem.FilePath); if (sheetsList == null) { MessageBox.Show("Error, invalid format, make sure you are using an Excel File."); return; } cmbSheetName.Items.AddRange(sheetsList.ToArray()); if (!string.IsNullOrWhiteSpace(sourceItem.SheetName)) cmbSheetName.Text = sourceItem.SheetName; }
private void btnSelectSourceFiles_Click(object sender, EventArgs e) { var result = openFileDialog1.ShowDialog(); if (result != DialogResult.OK) return; txtSource.Text = openFileDialog1.FileName; sourceItem = new ExcelFileItem() { FilePath = openFileDialog1.FileName }; sourceItemBindingSource.DataSource = sourceItem; FillSheets(sourceItem); }