protected void ButtonDummy_Click(object sender, EventArgs e)
        {
            try
            {
                //导出数据
                string name = DateTime.Now.ToString("yyyymmddhhmmss");
                string path = Server.MapPath("~/Upload/导出Excel/" + name + ".xls");
                ToExcel(path);

                System.IO.FileInfo file = new System.IO.FileInfo(path);
                Response.Clear();
                Response.Charset = "GB2312";
                Response.ContentEncoding = System.Text.Encoding.UTF8;
                //   添加头信息，为"文件下载/另存为"对话框指定默认文件名   
                Response.AddHeader("Content-Disposition", "attachment;   filename=" + Server.UrlEncode(file.Name));
                //   添加头信息，指定文件大小，让浏览器能够显示下载进度   
                Response.AddHeader("Content-Length", file.Length.ToString());

                //   指定返回的是一个不能被客户端读取的流，必须被下载   
                Response.ContentType = "application/ms-excel";

                //   把文件流发送到客户端   
                Response.WriteFile(file.FullName);
                //   停止页面的执行   
                Response.Flush();
                Response.End();

            }
            catch (Exception ex)
            {
                ExceptionLogger.LogException("SaleReport.ButtonDummy_Click", new ZeroGlobalException(ExceptionType.UnknownError.ToString(), ex));
            }
        }

        /// <summary>
        /// 导出Excel
        /// </summary>
        private void ToExcel(string strExcelFileName)
        {
            try
            {
                object objOpt = Missing.Value;
                Application excel = new Application();//实例化一个Excel
                _Workbook wkb = excel.Workbooks.Add(objOpt);
                _Worksheet wks = (_Worksheet)wkb.ActiveSheet;

                #region 设置格式
                wks = (_Worksheet)wkb.Worksheets.Add(Missing.Value, Missing.Value, 1, Missing.Value);
                wks.Name = "人员";
                excel.get_Range(excel.Cells[1, 1], excel.Cells[1, 4]).MergeCells = true;
                wks.get_Range("A1", "L1").get_Value(System.Type.Missing);
                excel.Cells[1, 1] = "基本信息"；
                  excel.Cells[6, 1] = "名字";
                wkb.SaveAs(strExcelFileName, objOpt, null, null, null, null, XlSaveAsAccessMode.xlShared, null, null, null, null, null);
                wkb.Close(false, objOpt, objOpt);
              
                excel.Quit();