private void Load_Click(object sender, RoutedEventArgs e) { if (selectsheet == null) return; Loadbutton.IsEnabled = false; loadprogress.Visibility = Visibility.Visible; reader = new ExcelReader(excelpath.Text); selectsheet.StartRange = Sr.Text; selectsheet.EndRange = Er.Text; backworkthread = new BackgroundWorker(); backworkthread.WorkerSupportsCancellation = true; backworkthread.DoWork += new DoWorkEventHandler(longtask); backworkthread.RunWorkerCompleted += new RunWorkerCompletedEventHandler(LongtaskComplete); backworkthread.RunWorkerAsync(); }
private void Open_Click(object sender, RoutedEventArgs e) { OpenFileDialog open = new OpenFileDialog(); open.Title = "打开Excel文件"; open.Filter = "Excel files (*.xlsx)|*.xlsx|All files (*.*)|*.xls"; open.FilterIndex = 1; open.RestoreDirectory = true; if (open.ShowDialog() == true) { excelpath.Text = open.FileName; //read the excel basic imformation ExcelReader reader = new ExcelReader(open.FileName); foreach (SheetInfo info in reader.GetSheetlist()) { sheetlist.Add(info); } sheetcmb.ItemsSource = sheetlist; } }