Import data dari EXCEL ke DATAGRIDVIEW

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.OleDb;

namespace coba7

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        private void button1_Click(object sender, EventArgs e)

        {

            try

            {

                using (OpenFileDialog ofd = new OpenFileDialog() { Filter = "Excel WorkBook 97-2003|*.xls|Excel WorkBook|*.xlsx", ValidateNames = true })

                {

                    if (ofd.ShowDialog() == DialogResult.OK){

                        String name = "Sheet1";

                        String constr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +

                                        ofd.FileName +

                                        ";Extended Properties='Excel 12.0 XML;HDR=YES;';";

                        OleDbConnection con = new OleDbConnection(constr);

                        OleDbCommand oconn = new OleDbCommand("Select * From [" + name + "$]", con);

                        con.Open();

                        OleDbDataAdapter sda = new OleDbDataAdapter(oconn);

                        DataTable data = new DataTable();

                        sda.Fill(data);

                        dataGridView1.DataSource = data;

                    }

                }

            }

            catch (Exception ex) { string errormsg = ex.ToString(); }

        }       

    }

}