注冊|登錄

聯系電話:024-31891684  13390130939
沈陽軟件公司--沈陽軟件定制

沈陽軟件開發_沈陽軟件公司_沈陽軟件定制/軟件/最新技術

Latest technology最新技術

asp.net到出excel表

瀏覽量:3443

今天研究一下導出excel表格,在網上看了看別人的代碼,自己也寫了一個小例子。

 

DProjectLedgerdpl = new DProjectLedger();

            MProjectLedger mp = new MProjectLedger();

            if (StringUtil.GetQueryString("projectnumber") != "")

            {

                mp.projectnumber = Server.UrlDecode(StringUtil.GetQueryString("projectnumber"));

         

            }

            if (StringUtil.GetQueryString("pname") != "")

            {

                mp.projectname = Server.UrlDecode(StringUtil.GetQueryString("pname"));

          

            }

            if (StringUtil.GetQueryString("sgdz") != "")

            {

                mp.sgdz = Server.UrlDecode(StringUtil.GetQueryString("sgdz"));

            

            }

            if (StringUtil.GetQueryString("sgdw") != "")

            {

                mp.constructionUnit = Server.UrlDecode(StringUtil.GetQueryString("sgdw").TrimEnd(','));

              

            }

            if (StringUtil.GetQueryString("sgqy") != "")

            {

                mp.constructionArea = Server.UrlDecode(StringUtil.GetQueryString("sgqy"));

              

            }

            if (StringUtil.GetQueryString("zyxf") != "")

            {

                mp.zyxf = Server.UrlDecode(StringUtil.GetQueryString("zyxf"));

       

            }

            if (StringUtil.GetQueryString("progress") != "")

            {

                mp.progress = Server.UrlDecode(StringUtil.GetQueryString("progress"));

            

            }

            string years = "";

            if (Request.QueryString["years"] != null)

            {

                years = Request.QueryString["years"];

            }

            if (years == "")

            {

                years = DateTime.Now.ToString("yy");

            }

  

            mp.sgdzname = years;

            if (Request.QueryString["htkgrqs"] != null)

            {

                mp.htkgrqs = Request.QueryString["htkgrqs"];

              

            }

            if (Request.QueryString["htkgrqz"] != null)

            {

                mp.htkgrqz = Request.QueryString["htkgrqz"];

             

            }

            if (Request.QueryString["htjgrqs"] != null)

            {

                mp.htjgrqs = Request.QueryString["htjgrqs"];

             

            }

            if (Request.QueryString["htjgrqz"] != null)

            {

                mp.htjgrqz = Request.QueryString["htjgrqz"];              

            }

            mp.id = StringUtil.GetQueryInt("sort");

            Workbook workbook = new Workbook();

            Worksheet sheet = (Worksheet)workbook.Worksheets[0];

            string[] st = { "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z", "AA", "AB", "AC", "AD", "AE", "AF", "AG", "AH", "AI", "AJ", "AK", "AL", "AM", "AN", "AO", "AP", "AQ", "AR", "AS", "AT", "AU", "AV", "AW", "AX", "AY", "AZ" };

            int i = 1;

            string column="";

            string cont = "";

            sheet.Cells[st[0] + "1"].PutValue("序號");

            foreach (ListItem lt in cbziduan.Items)

            {

                if (lt.Selected)

                {

                    sheet.Cells[st[i] + "1"].PutValue(lt.Text);                 

                    if (lt.Value != "constructionUnits")

                    {                    

                        column += lt.Value + ",";

                    }

                    else

                    {

                        cont = "bumen";

                    }

                    i++;

                }

            }

      

            int RowNo = 2;

            string tys = "";

            if (Request.QueryString["tys"] != null)

            {

                tys = viewdepart;

            }

            //讀取數據庫

            DataTable dt = dpl.GetToEduce(column, mp, tys, cont);

            for (int j = 0; j < dt.Rows.Count; j++)

            {

                sheet.Cells[st[0] + RowNo].PutValue((j+1).ToString());

                for (int n = 1; n <= dt.Columns.Count; n++)

                {

                    sheet.Cells[st[n] + RowNo].PutValue(dt.Rows[j][n-1].ToString());

                }

                RowNo++;

            }

       String filename = string.Format("{0}{1}.xls", "saleranklist", Convert.ToDateTime(DateTime.Now).ToString("yyyyMMdd")); //文件默認命名方式,可以自定義

 

            Response.ContentType = "application/ms-excel;charset=utf-8";

 

            Response.AddHeader("content-disposition", "attachment; filename=" + filename);

 

            System.IO.MemoryStream memStream = workbook.SaveToStream();

 

            Response.BinaryWrite(memStream.ToArray());

 

            Response.End();

沈陽團購網|營口網站制作|沈陽軟件公司|軟件定制|網站建設|加盟易勢|提交問題

主站蜘蛛池模板: 两个人日本免费完整版在线观看1 两个人的视频www免费 | 夜夜高潮天天爽欧美| 久久99国产精品久久99果冻传媒 | 扒开双腿猛进湿润18p| 乱人伦精品视频在线观看| 欧美激情一区二区三区视频| 免费看黄视频app| 老师你的兔子好软水好多的车视频 | 国产网红主播无码精品| www.日韩三级www.日日爱| 老阿姨哔哩哔哩b站肉片茄子芒果| 国产精品久久久久久久久久免费 | 亚洲人成色7777在线观看不卡| 狂野欧美性猛xxxx乱大交| 午夜精品久久久久久久| 菠萝蜜视频在线播放| 国产成人永久免费视频| 色多多视频在线观看| 国产黄三级三·级三级| 一区二区三区视频| 成人在线播放av| 久久久久99精品国产片| 日韩在线一区二区| 亚洲中文字幕无码久久综合网| 毛片免费观看网址| 国产小视频免费在线观看| 10天的爱人下载| 国内午夜免费鲁丝片| MM1313亚洲精品无码| 好爽好紧好多水| 中国在线观看免费的www| 无码精品人妻一区二区三区影院| 久久精品国产成人AV| 极品丝袜乱系列大全集目录| 免费观看美女裸体网站| 老司机福利精品视频| 国产三级日产三级韩国三级韩级 | 一级成人生活片免费看| 成年美女黄网站色大片免费看 | 91福利精品老师国产自产在线| 天天影视综合色|