Question

C# Winfrom 如何把Excel文件导入到dataGridView 并显示？

在网上看了各种代码 不是这边错就是那边有问题
求大神帮我弄下啊
麻烦说详细点 我小白 可以的话帮我远程下 我QQ

Answer 1

public DataSet ReadExcel_ds(string FilePath) { string subfile = FilePath.Substring(FilePath.LastIndexOf(".") + 1); DataSet ds = new DataSet(); string strCon = ""; if (subfile.ToUpper() == "XLS") { strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;data source=" + FilePath; } if (subfile.ToUpper() == "XLSX")//excel2007读取 { strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath + ";Extended Properties=\"Excel 12.0;HDR=YES\""; } System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection(strCon); try { Conn.Open(); System.Data.DataTable sTable = Conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);//新添加 2010-10-14 string tableName = sTable.Rows[0][2].ToString().Trim();//新添加 2010-10-14 获取工作表名称 string strCom = "SELECT * FROM [" + tableName + "] "; System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strCom, Conn); myCommand.Fill(ds, "[" + tableName + "]"); } catch (Exception Ex) { MessageBox.Show(Ex.Message); } finally { Conn.Close(); } return ds; }

Answer 2

这个还真不太清楚。。。我要查一下资料。然后跟你说。