Net读取(上传的)Excel内容显示到GridView示例源代码

Net读取(上传的)Excel内容显示到GridView示例源代码

Admin | 2008-1-21 8:18:58 | TrackRecord: 1949 Times | Tag标签：asp.net 打印本页

您当前所处的位置是：〖首页〗→【文章页】本站共有16个图文教程栏目,请用心拜读!

本站提供经典的Excel公式函数实例,Word排版技巧,PPT教程;同时更兼有Flash,PowerPoint,数据库等技术文章。

网上转载……

//上传文件
            string filename = FileUpload1.FileName;
            string path = Server.MapPath("c:\\123\\" + filename);
            FileUpload1.SaveAs(path);

            string strConn = GetExcelConnString(path);
            OleDbConnection conn = new OleDbConnection(strConn);
            try
            {
                conn.Open();
            }
            catch (Exception ex)
            {
                //ShowClientJS("ShowInfo(\"错误：" + ex.Message + "\",1,5000);", this);
                return;
            }

//判断工作表个数
            DataTable dtTblNames = conn.GetSchema("Tables");
            if (dtTblNames.Rows.Count > 1)
            {
                conn.Close();
                //ShowClientJS("ShowInfo('导入失败：只允许1个工作表，当前有：" + dtTblNames.Rows.Count.ToString() + "',1,5000);", this);
                return;
            }
//只处理第一个工作表
            string tblName = dtTblNames.Rows[0]["Table_Name"].ToString();
            hidTableName.Value = tblName;
            OleDbCommand cmd = new OleDbCommand();
            cmd.Connection = conn;
            cmd.CommandText = "select * from [" + tblName + "]";
            OleDbDataAdapter da = new OleDbDataAdapter(cmd);
            DataTable dt = new DataTable();
            try
            {
                da.Fill(dt);
            }
            catch (Exception ex)
            {
                //ShowClientJS("ShowInfo(\"预览时发生错误：" + ex.Message + "\",1,5000);", this);
            }
            finally
            {
                conn.Close();
            }
//显示数据
            GridView1.DataSource = dt;
            GridView1.DataBind();