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