private void DoBrowse()
{
System.Windows.Forms.OpenFileDialog openFile = new System.Windows.Forms.OpenFileDialog();
openFile.Filter = @"Excel Files|*.xls;*.xlsx;*.xlsm";
openFile.RestoreDirectory = true;
openFile.ShowDialog();
_ExcelFile = openFile.FileName;
TextBox_File.Text = _ExcelFile;
this.ComboBox_Sheet.ItemsSource = ExcelReaderWriterHelper.GetSheetInfos(_ExcelFile, true);
}
private void ComboBox_Sheet_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (this.ComboBox_Sheet.SelectedIndex > -1)
{
this._SheetInfo = (SheetInfo)this.ComboBox_Sheet.SelectedItem;
ExcelReaderWriterHelper.SetColumnInfos(_ExcelFile, this._SheetInfo);
ColumnInfo cInfoEmpty = new ColumnInfo()
{
Index = 0,
Header = string.Empty,
Name = string.Empty,
};
this._SheetInfo.Columns.Insert(0, cInfoEmpty);
DataGridComboBoxColumn_Columns.ItemsSource = null;
DataGridComboBoxColumn_Columns.ItemsSource = this._SheetInfo.Columns;
StackPanel_SheetInfo.DataContext = this._SheetInfo;
}
}
