using (DataSet ds = new DataSet())
{
string strCon = @"Provider=Microsoft.Ace.OLEDb.12.0;Data Source='{0}';Extended Properties='Excel 12.0;HDR=no;IMEX=1';";
strCon = string.Format(strCon, filePath);
if(textBox2.Text.ToString().Trim() == "")
{
MessageBox.Show("请配置要读取的Excel表单名");
return;
}
string strCom = string.Format(" SELECT * FROM [{0}$]", textBox2.Text.ToString().Trim());//B_AMountData01
using (OleDbConnection myConn = new OleDbConnection(strCon))
using (OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn))
{
myConn.Open();
myCommand.Fill(ds);
}
if (ds == null || ds.Tables.Count <= 0)
return ;
dt = ds.Tables[0];
backgroundWorker1.ReportProgress(100);
}