[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["字段"], ... }); }
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
社区成员
642,554
社区内容
加载中
让您成为最强悍的C#开发者
试试用AI创作助手写篇文章吧