读Excel到DataTable

最新推荐文章于 2024-10-09 16:02:44 发布

tangsw

最新推荐文章于 2024-10-09 16:02:44 发布

阅读量262

点赞数

分类专栏： .net 文章标签： excel string properties

本文链接：https://blog.csdn.net/tangsw/article/details/5747369

版权

.net 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

//读Excel到DataGridView
        private void RedExcel()
        {
            string sPath = "F://excel名称.xls";
            string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + sPath + ";Extended Properties='Excel 8.0;HDR=NO;IMEX=1'";

            string strSQL = "SELECT * FROM [sheet1$]";
            OleDbConnection excelConnection = new OleDbConnection(connectionString);
            excelConnection.Open();

            OleDbCommand dbCommand = new OleDbCommand(strSQL, excelConnection);
            OleDbDataAdapter dataAdapter = new OleDbDataAdapter(dbCommand);

            DataTable dTable = new DataTable();

            dataAdapter.Fill(dTable);

            dataGridView1.DataSource = dTable;

            dTable.Dispose();
            dataAdapter.Dispose();
            dbCommand.Dispose();
            excelConnection.Close();
            excelConnection.Dispose();
        }