reading a excel file

public DataTable readExcell(string FILE_MAP)

{

string conn = "Provider=Microsoft.ACE.OLEDB.12.0;" +

"Data Source=" + FILE_MAP + ";" +

"Extended Properties=\"Excel 12.0;HDR=yes;IMEX=1\"";

OleDbConnection oledbConn = new OleDbConnection(conn);

oledbConn.Open();

DataTable dtData = new DataTable();

DataTable dtSheet = oledbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,

new object[] { null, null, null, "TABLE" });

if (dtSheet.Rows.Count > 0)

{

OleDbCommand cmd = new OleDbCommand("SELECT * FROM [" +

dtSheet.Rows[0]["TABLE_NAME"].ToString() + "]", oledbConn);

OleDbDataAdapter oleda = new OleDbDataAdapter();

oleda.SelectCommand = cmd;

oleda.Fill(dtData);

}

oledbConn.Close(); oledbConn = null;

return dtData;

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.