读Excel表的难题
用以下语句读Excel表时,如果Excel表中的网格的内容是数字并且不是在键盘手工输入,即从别的地方copy过来时,会读不出来,无论你把该格的属性设成什么也一样,大家有什么好的办法?
Eanme = @"c:\abc\abc.xls"
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=";
strConn += Ename.ToString();
strConn += ";Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet,"mytable");
DataGrid3.DataSource = myDataSet.Tables["mytable"].DefaultView;
DataGrid3.DataBind();