注冊|登錄

聯(lián)系電話:024-31891684  13390130939
沈陽軟件公司--沈陽軟件定制

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

Latest technology最新技術

asp.net到出excel表

瀏覽量:3444

今天研究一下導出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;

            }

            //讀取數(shù)據(jù)庫

            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();

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

主站蜘蛛池模板: 国产激情视频一区二区三区| 日本三级电电影在线看| 免费a级毛片大学生免费观看| 青青青爽在线视频观看| 国产精品影音先锋| a级片在线观看视频| 抵在洗手台挺进撞击bl| 久久精品欧美日韩精品| 欧美日本高清在线不卡区| 人妻一本久道久久综合久久鬼色| 美女内射毛片在线看3D| 国产免费黄色大片| 久久福利资源网站免费看 | 亚洲欧美成人综合| 男人j桶进女人p无遮挡免费 | 亚洲另类专区欧美制服| 热久久99影院| 免费鲁丝片一级在线观看| 色噜噜久久综合伊人一本| 国产在线麻豆精品观看| 亚洲五月综合缴情婷婷| 国产香蕉国产精品偷在线| www.夜夜操.com| 性xxxx黑人与亚洲| 中文字幕在线网址| 日本亚州视频在线八a| 久久精品国产亚洲av水果派| 校园亚洲春色另类小说合集| 亚洲成年人免费网站| 热久久天天拍天天拍热久久2018| 免费人成黄页在线观看视频国产| 精品欧洲男同同志videos| 国产AV一区二区三区无码野战| 青娱乐国产在线视频| 国产成人av区一区二区三| 欧美浮力第一页| 国产精品久久久久影院嫩草| 2022国产麻豆剧果冻传媒入口| 国内精品久久久久久无码不卡| 99视频在线观看免费| 天天狠天天透天干天天怕∴|