.net 查詢Excel
public static DataTable GetCSVDataTable(string FileName) { System.Data.OleDb.OleDbConnection cn = null; DataTable dt = new DataTable(); string strSheet = ""; try { string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FileLocation + ";Extended Properties='Text;HDR=yes'"; //查詢語句 cn = new System.Data.OleDb.OleDbConnection(strConn); cn.Open(); Object[] objs = new Object[] { null, null, null, "TABLE" }; dt = cn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, objs); if (dt.Rows.Count > 0) { strSheet = dt.Rows[0]["TABLE_NAME"].ToString(); } dt = new DataTable(); string strSql = "SELECT * FROM [" + FileName + "] "; System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(strSql, strConn); da.Fill(dt); } catch (Exception Ex) { throw Ex; } finally { if ((cn != null)) { cn.Close(); } if ((System.IO.File.Exists(FileLocation + FileName))) { System.IO.File.Delete(FileLocation + FileName); } } return dt; }