Question

c#，如何将excel文件导入datagridview？

如题，举个简单的例子

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;
}