|
|
 | | From: | =?Utf-8?B?Ymx1ZXNreQ==?= | | Subject: | =?Utf-8?B?5aaC5L2V6K+75Y+WZXhjZWzmlbDmja7jgII=?= | | Date: | Thu, 20 Jan 2005 05:31:02 -0800 |
|
|
 | string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =
c:\\1.xls;Extended Properties=Excel 8.0";
OleDbConnection myConn = new OleDbConnection(strCon);
string strCom = " SELECT * FROM [Sheet1$] ";
myConn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);
myDataSet = new DataSet();
myCommand.Fill(myDataSet, "[Sheet1$]");
myConn.Close();
得到的数据只能是数字型的如203、204之类
如字符型的数据203-1之类读取时为空。
如何才能在C#中读取电子表格的数据。谢谢！
|
|
|
