上传附件读取exl

 

   //上传附件
        if ((this.FileUpload1.HasFile))
        {

            OleDbConnection conn = new OleDbConnection();
            OleDbCommand cmd = new OleDbCommand();
            OleDbDataAdapter da = new OleDbDataAdapter();
            DataSet ds = new DataSet();
            string query = null;
            string connString = "";
            string strFileName = DateTime.Now.ToString("ddMMyyyy_HHmmss");
            string strFileType = System.IO.Path.GetExtension(FileUpload1.FileName).ToString().ToLower();

            if (strFileType == ".xls" || strFileType == ".xlsx")
            {
                FileUpload1.SaveAs(Server.MapPath("~/Upload/" + strFileName + strFileType));
                string strNewPath = Server.MapPath("~/Upload/" + strFileName + strFileType);

                if (strFileType.Trim() == ".xls")
                {
                    connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strNewPath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
                }
                else if (strFileType.Trim() == ".xlsx")
                {
                    connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strNewPath + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
                }
                conn = new OleDbConnection(connString);
                if (conn.State == ConnectionState.Closed || conn.State == ConnectionState.Broken) conn.Open();
                //返回Excel的架构，包括各个sheet表的名称,类型，创建时间和修改时间等 
                DataTable dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" });
                //包含excel中表名的字符串数组
                string[] strTableNames = new string[dtSheetName.Rows.Count];
                for (int k = 0; k < dtSheetName.Rows.Count; k++)
                {
                    strTableNames[k] = dtSheetName.Rows[k]["TABLE_NAME"].ToString();
                }
                //从指定的表明查询数据,可先把所有表明列出来供用户选择
                query = "select * from [" + strTableNames[0] + "]";
                cmd = new OleDbCommand(query, conn);
                da = new OleDbDataAdapter(cmd);
                ds = new DataSet();
                da.Fill(ds);
                int a = ds.Tables[0].Rows.Count;
            
                da.Dispose();
                conn.Close();
                conn.Dispose();
}  else
            {

                this.Page.RegisterStartupScript("", "<script>alert('上传失败只能上传 xlsx或是 xls！')</script>");
                return;
            }