代碼如下:
protected void Button1_Click(object sender, EventArgs e)
        {

            if (FileUpload1.HasFile == false)
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "shifou", "<script>alert('請您選擇   Excel文件')</script> ");
                return;
            }
            string Name = FileUpload1.PostedFile.FileName; //獲取初始文件名
            int j = Name.LastIndexOf("."); //取得文件名中最后一個"."的索引
            string newext1 = Name.Substring(j); //獲取文件擴展名
            if (newext1 != ".xls" && newext1 != ".xlsx")
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "wenjian", "<script>alert('只可以選擇  Excel文件')</script>");
                return;//當(dāng)選擇的不是Excel文件時,返回
            }
            SqlConnection cn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
            cn.Open();
            //savePath = Path.GetFullPath(FileUpload1.PostedFile.FileName);//    FileUpload1.PostedFile.FileName.ToString();
            if (FileUpload1.HasFile == false)//HasFile用來檢查FileUpload是否有指定文件
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "wenjian", "<script>alert('Excel路徑有  問題')</script>");
                return;//當(dāng)無文件時,返回
            }

            filename = FileUpload1.FileName;  //Path.GetFileNameWithoutExtension  (FileUpload1.PostedFile.FileName);
            savePath = Server.MapPath(("../../UploadFiles/xls/") + filename);