下载excel模板

来源：互联网发布：手机远程拍照软件编辑：程序博客网时间：2024/04/26 18:28

下载事件中写

Page.ClientScript.RegisterStartupScript(GetType(), "alert", "alert('测试成功！');", true);

            System.IO.FileInfo file = new System.IO.FileInfo(Server.MapPath("../fellowship/template.xls"));//在项目的位置下放个Excel
            Response.Clear();
            Response.AddHeader("Content-Disposition", "attachment;   filename=" + file.Name);
            Response.AddHeader("Content-Length", file.Length.ToString());
            Response.ContentType = "application/octet-stream";
            Response.WriteFile(file.FullName);
            Response.End();
            Response.Flush();
            Response.Clear();

导入excel内容事件写这个方法

        private void uploadOperation()
        {
            //string fileName = "";

            // fileName = Request.QueryString["fileName"].Trim();
            if (!this.fileUpload.FileName.Substring(this.fileUpload.FileName.LastIndexOf(".")).ToUpper().Equals(".XLS"))
            {
                Page.ClientScript.RegisterStartupScript(GetType(), "alert", "alert('只能导入Excel文件！')", true);
                return;

}

            // ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "updatepanel2", "alert('测试成功！');", true);
            string oldfileName = this.fileUpload.FileName;
            string newfileName = JinRi.Logic.GroupTicket.get_OrderNo(base.authorInfo.UserId) + ".xls";

this.fileUpload.SaveAs(Server.MapPath(@"~/fellowship/" + newfileName + ""));
StringBuilder xmlnode = new StringBuilder();

            DataTable dt = selectExcel(newfileName);
            if (dt != null)
            {
                Session["uploadFileName"] = newfileName;
            }
            else
            {
                Session["uploadFileName"] = null;
            }

}

private DataTable selectExcel(string fileName)
{

// 连接字符串
string xlsPath = Server.MapPath("~/fellowship/" + fileName + "");

            if (xlsPath == "")
            {
                return null;
            }
            // 相对物理路径:
            string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Extended Properties=/"Excel 8.0;IMEX=1;HDR=NO;/";" + "data source=" + xlsPath;

// 查询语句
string sql = "SELECT * FROM [Sheet1$]";

            if (!System.IO.File.Exists(xlsPath))
            {
                throw new Exception("文件不存在!");
            }

DataSet ds = new DataSet();

            OleDbDataAdapter da = new OleDbDataAdapter(sql, connStr);
            try
            {
                da.Fill(ds); // 填充DataSet

                if (ds.Tables[0].Rows.Count > 501)
                {
                    this.txtUpload.Value = "error1";

                }
                else if (ds.Tables[0].Columns.Count != 2)
                {
                    this.txtUpload.Value = "error2";

                }
                else
                {
                    this.txtUpload.Value = "yes";

}

            }
            catch (Exception)
            {
                return null;
                //throw new Exception(ex.Message);//则抛出的是系统自己的异常信息.

//throw new UploadExeception("上传的Excel文件被占用,请关闭这个文件!");//抛出的是用户自定义的异常信息.
}

            // 在这里对DataSet中的数据进行操作
            // 输出，绑定数据
            return ds.Tables[0];

}