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);
}
