从Excel中读取数据

string xlsPath = FileUpload1.PostedFile.FileName;

string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1\";" + "data source=" + xlsPath;
OleDbConnection cnnxls = new OleDbConnection(connStr);
OleDbDataAdapter myDa = new OleDbDataAdapter("select * from [Sheet1$] ", cnnxls);
DataSet myDs = new DataSet();
myDa.Fill(myDs);

posted @ 2012-04-28 13:49  challengesoflife  阅读(138)  评论(0编辑  收藏  举报