主程序代码
private void MenuItem2_Click(object sender, RoutedEventArgs e)
{
string fName = "";
DataTable dt = new DataTable();
//用于获取excel文件名
Microsoft.Win32.OpenFileDialog open = new Microsoft.Win32.OpenFileDialog();
open.Filter = "Excel(*.xlsx)|*.xlsx|Excel(*.xls)|*.xls";
if (open.ShowDialog() ==false) return;
fName = open.FileName;
string connstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fName + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1';"; // Office 07及以上版本 //string connstring = Provider=Microsoft.JET.OLEDB.4.0;Data Source=" + path + ";Extended Properties='Excel 8.0;HDR=NO;IMEX=1';"; //Offi