c#读取Excel中代码到dataGridView中

项目开发中，经常会遇到将Excel中的数据读取出来，在dataGridView中显示，最后倒入到数据库中。实现方法如下：

1、添加引用，分别为：Microsoft.Office.Interop.Excel 和 Microsoft.Office.Interop.Excel，并引用到代码中，using Microsoft.Office.Interop.Excel和using Excel = Microsoft.Office.Interop.Excel。
2、新建类，代码实现：

 private void skinButton1_Click(object sender, EventArgs e)
        {
            doubleClick = false;
            skinButton2.Enabled = true;
            dt = new System.Data.DataTable();
            OpenFileDialog ofd = new OpenFileDialog();
            ofd.Filter = "Excel Files|*.xls";
            if (ofd.ShowDialog() == DialogResult.OK)
            {
                String filename = ofd.FileName;
                Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
                Microsoft.Office.Interop.Excel.Workbook workbook;
                Microsoft.Office.Interop.Excel.Worksheet worksheet;
                object oMissing = System.Reflection.Missing.Value;//相当null
                workbook = excel.Workbooks.Open(filename, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
                worksheet = (Worksheet)workbook.Worksheets[1];
                int rowCount = worksheet.UsedRange.Rows.Count;
                Console.WriteLine(rowCount);
                int colCount = worksheet.UsedRange.Columns.Count;
                Microsoft.Office.Interop.Excel.Range range1;
                for (int i = 0; i < colCount; i++)
                {
                    range1 = worksheet.Range[worksheet.Cells[1, i + 1], worksheet.Cells[1, i + 1]];
                    dt.Columns.Add(range1.Value2.ToString());
                }
                for (int j = 1; j < rowCount; j++)
                {
                    DataRow dr = dt.NewRow();
                    for (int i = 0; i < colCount; i++)
                    {
                        range1 = worksheet.Range[worksheet.Cells[j + 1, i + 1], worksheet.Cells[j + 1, i + 1]];
                        dr[i] = range1.Value2 == null ? null : range1.Value2;
                    }
                    dt.Rows.Add(dr);
                }
                skinDataGridView1.DataSource = null;
                skinDataGridView1.DataSource = dt;
                //dataGridView1.Rows[0].Selected = false;
                skinDataGridView1.ClearSelection();
                excel.Quit();
            }
        }

3、实现效果：