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

xzh1995 2013-08-10 06:23:20
C# winform 怎么把excel数据导入到listview里面 麻烦给个例子 谢谢
...全文
733 6 打赏 收藏 转发到动态 举报
AI 作业
写回复
用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
  • 打赏
  • 举报
回复
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["字段"], ... }); }

111,094

社区成员

发帖
与我相关
我的任务
社区描述
.NET技术 C#
社区管理员
  • C#
  • AIGC Browser
  • by_封爱
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告

让您成为最强悍的C#开发者

试试用AI创作助手写篇文章吧