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