C#中判斷上傳類型為Excel，03和07版的連結字串

有時候經常用到，做個記錄

判斷上傳檔案為Excel：

if ((this.FileUpload1.PostedFile.ContentType == "application/vnd.ms-excel") || (this.FileUpload1.PostedFile.ContentType == "application/ms-excel") || (this.FileUpload1.PostedFile.ContentType== "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")){}

03版Excel連結字串：

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(savePath) + ";Extended Properties='Excel 8.0;HDR=No;IMEX=1'";

07以上版Excel連結字串：

strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath(savePath) + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1';";