C#实现从EXCEL将数据导出到datagridview

 

源代码：

  public void ImportDataFromExcel(string filePathAndName)
        {         
            if (File.Exists(filePathAndName))
            {

                //连接字符串

                string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filePathAndName + ";" + "Extended Properties=Excel 8.0;";
                OleDbConnection conn = new OleDbConnection(strConn);
                //连接打开

                conn.Open();

                //获取EXCEL表格的框架，以便获得多个工作薄的数据
                DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
                DataSet ds = new DataSet();
                string tableName, strSql;

               //获得每一个工作簿的数据，都填充到数据集中
                for (int i = 0; i < schemaTable.Rows.Count; i++)