private void ExportExcel_Click(object sender, RoutedEventArgs e)
{
exportDataTable = importDataTable;
exportExcelHelper = new ExcelHelper.ExcelHelper("d:\\导出名单.xlsx");
exportExcelHelper.DataTableToExcel(exportDataTable, "导出名单", true);
MessageBox.Show("导出成功");
}
private void ImportExcel_Click(object sender, RoutedEventArgs e)
{
Microsoft.Win32.OpenFileDialog openFileDialog = new Microsoft.Win32.OpenFileDialog();
openFileDialog.InitialDirectory = "d:\\";
openFileDialog.Filter = "Microsoft Excel files(*.xls)|*.xls;*.xlsx";
openFileDialog.FilterIndex = 1;
bool?result = openFileDialog.ShowDialog();
if (result == true)
{
importDataTable = new System.Data.DataTable();
importExcelHelper = new ExcelHelper.ExcelHelper(openFileDialog.FileName);
importDataTable = importExcelHelper.ExcelToDataTable("抽奖人员", true);
dataGrid1.DataContext = importDataTable;
}
}
