C#读取EXCEL数据
我想读取EXCEL数据,要如何读取呢。Form1 里有个button1、ListView1控件,要如何写button1单击事件?xls文件工作表有6列,ListView也有6列。 --------------------编程问答-------------------- http://www.cnblogs.com/peterzb/archive/2009/07/06/1517395.html --------------------编程问答-------------------- string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";
using(OleDbConnection OleConn = new OleDbConnection(strConn))
{
OleConn.Open();
String sql = "SELECT * FROM [Sheet1$]";
OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql, OleConn);
DataSet ds= new DataSet();
OleDaExcel.Fill(ds);
OleConn.Close();
}
补充:.NET技术 , C#