C#将Excel中的数据读入DataGrid 头文件: using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.Data.OleDb; 代码: string strConn = @" Provider=Microsoft.Jet.OLEDB.4.0; " + @" Data Source=xls路径; " + @" Extended Properties=Excel 8.0; " ; OleDbConnection conn = new OleDbConnection(strConn); OleDbDataAdapter myCommand = new OleDbDataAdapter( " SELECT * FROM [Excel的Sheet名$] " , strConn); DataSet myDataSet = new DataSet(); myCommand.Fill(myDataSet); this .dataGrid1.DataSource = myDataSet; this .dataGrid1.DataMember = myDataSet.Tables[ 0 ].TableName; posted on 2005-04-21 17:35 K3 阅读( ...) 评论( ...) 编辑 收藏 转载于:https://www.cnblogs.com/sskset/archive/2005/04/21/142853.html