string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + path + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataTable dt =conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables_Info,new Object[] {null});
参考
http://topic.csdn.net/t/20041214/11/3643228.html
http://www.cnblogs.com/sanle/archive/2005/10/22/259761.html