Hi ,
Try this
String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Book1.xls;Extended Properties=\"Excel 8.0;Readonly=False;IMEX=0;\"";
using (OleDbConnection objConn = new OleDbConnection(sConnectionString))
{
objConn.Open();
using (OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [Sheet$]", objConn))
{
objCmdSelect.CommandType = CommandType.Text;
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter(objCmdSelect);
DataSet objDataset1 = new DataSet();
objAdapter1.Fill(objDataset1);
dataGridView1.DataSource = objDataset1.Tables[0];
dataGridView1.Columns[1].Visible = false ;
}
}
Best Regards
M.Mitwalli