C# winform 怎么把excel数据导入到listview里面麻烦给个例子谢谢

xzh1995 2013-08-10 06:23:20

...全文

733 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

Double K 2015-07-07

打赏
举报

static public DataSet ExcelToDataSet(string filename) { DataSet ds; string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Extended Properties=Excel 8.0;" + "data source=" + filename; OleDbConnection myConn = new OleDbConnection(strCon); string strCom = " SELECT * FROM [Sheet1$]"; myConn.Open(); OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn); ds = new DataSet(); myCommand.Fill(ds); myConn.Close(); return ds; } 然后循环添加 DataTable dt = ExcelToDataSet(filename).Tables[0]; listView.Columns.Add(...); listView.Columns.Add(...); listView.Columns.Add(...); foreach (var row in dt.Rows) { listView.Items.Add(new string[] { row["字段"], row["字段"], ... }); }

threenewbee 2013-08-10

打赏
举报

引用 4 楼 xzh1995 的回复:

[quote=引用 1 楼 caozhy 的回复:] static public DataSet ExcelToDataSet(string filename) { DataSet ds; string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Extended Properties=Excel 8.0;" + "data source=" + filename; OleDbConnection myConn = new OleDbConnection(strCon); string strCom = " SELECT * FROM [Sheet1$]"; myConn.Open(); OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn); ds = new DataSet(); myCommand.Fill(ds); myConn.Close(); return ds; } 然后循环添加 DataTable dt = ExcelToDataSet(filename).Tables[0]; listView.Columns.Add(...); listView.Columns.Add(...); listView.Columns.Add(...); foreach (var row in dt.Rows) { listView.Items.Add(new string[] { row["字段"], row["字段"], ... }); }

listView.Items.Add(new string[] { row["字段"], row["字段"], ... });报错[/quote] 给你的是大致的演示，根据你的需要修改下。

xzh1995 2013-08-10

打赏
举报

引用 1 楼 caozhy 的回复:

static public DataSet ExcelToDataSet(string filename) { DataSet ds; string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Extended Properties=Excel 8.0;" + "data source=" + filename; OleDbConnection myConn = new OleDbConnection(strCon); string strCom = " SELECT * FROM [Sheet1$]"; myConn.Open(); OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn); ds = new DataSet(); myCommand.Fill(ds); myConn.Close(); return ds; } 然后循环添加 DataTable dt = ExcelToDataSet(filename).Tables[0]; listView.Columns.Add(...); listView.Columns.Add(...); listView.Columns.Add(...); foreach (var row in dt.Rows) { listView.Items.Add(new string[] { row["字段"], row["字段"], ... }); }

listView.Items.Add(new string[] { row["字段"], row["字段"], ... });报错

xzh1995 2013-08-10

打赏
举报

引用 1 楼 caozhy 的回复:

static public DataSet ExcelToDataSet(string filename) { DataSet ds; string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Extended Properties=Excel 8.0;" + "data source=" + filename; OleDbConnection myConn = new OleDbConnection(strCon); string strCom = " SELECT * FROM [Sheet1$]"; myConn.Open(); OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn); ds = new DataSet(); myCommand.Fill(ds); myConn.Close(); return ds; } 然后循环添加 DataTable dt = ExcelToDataSet(filename).Tables[0]; listView.Columns.Add(...); listView.Columns.Add(...); listView.Columns.Add(...); foreach (var row in dt.Rows) { listView.Items.Add(new string[] { row["字段"], row["字段"], ... }); }

那个连接字符串可以怎么得到

xzh1995 2013-08-10

打赏
举报

引用 1 楼 caozhy 的回复:

static public DataSet ExcelToDataSet(string filename) { DataSet ds; string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Extended Properties=Excel 8.0;" + "data source=" + filename; OleDbConnection myConn = new OleDbConnection(strCon); string strCom = " SELECT * FROM [Sheet1$]"; myConn.Open(); OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn); ds = new DataSet(); myCommand.Fill(ds); myConn.Close(); return ds; } 然后循环添加 DataTable dt = ExcelToDataSet(filename).Tables[0]; listView.Columns.Add(...); listView.Columns.Add(...); listView.Columns.Add(...); foreach (var row in dt.Rows) { listView.Items.Add(new string[] { row["字段"], row["字段"], ... }); }

非常感谢先研究研究

threenewbee 2013-08-10