asp.net DataSet数据导出到Excel中

方法:

[STAThread]///这是必须的
    public override void VerifyRenderingInServerForm(System.Web.UI.Control control)
    {
        //base.VerifyRenderingInServerForm(control);
    }

 public void OutExcel()     {        

    dsExcel = OPA_HistoryEmployee.GetChineseHistoryEmployeeList(opa_historyemployee);

        opa_appraiseinfo.ID=AppInfoId;         opa_appraiseinfo.CompanyID = CompanyID;

        opa_appraiseinfo = OPA_AppraiseInfo.GetAppraiseInfoByID(opa_appraiseinfo);

        string FileName = opa_appraiseinfo.Title+"_"+DateTime.Now.ToString("yyyy年MM月dd日")+".xls";

        HttpResponse resp;         resp = Page.Response;

        resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");

        resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);

        resp.ContentType = "application/vnd.ms-xls";

        string colHeaders = "", ls_item = "";

        int i = 0;

        //定义表对象和行对像,同时用DataSet对其值进行初始化

        DataRow[] myRow = dsExcel.Tables[0].Select();

        //取得数据表各列标题,各标题之间以\t分割,最后一个列标题后加回车符

        for (i = 0; i < dsExcel.Tables[0].Columns.Count; i++)         {  

           if (i == dsExcel.Tables[0].Columns.Count - 1)             {

                colHeaders += dsExcel.Tables[0].Columns[i].Caption.ToString() + "\n";     

        }  else   

          {       

          colHeaders += dsExcel.Tables[0].Columns[i].Caption.ToString() + "\t";      

       }      

   }         //向HTTP输出流中写入取得的数据信息

        resp.Write(colHeaders);   

      //逐行处理数据   

      foreach (DataRow row in myRow)         {           

  //在当前行中,逐列获得数据,数据之间以\t分割,结束时加回车符\n  

           for (i = 0; i < dsExcel.Tables[0].Columns.Count; i++)   

          {

                if (i == dsExcel.Tables[0].Columns.Count - 1)      

           {      

               ls_item += row[i].ToString() + "\n";         

        }   else    

             {      

               ls_item += row[i].ToString() + "\t";         

        }        

     }     

        //当前行数据写入HTTP输出流,并且置空ls_item以便下行数据  

           resp.Write(ls_item);       

      ls_item = "";    

     }

        resp.End();     }

posted @ 2013-07-10 10:38  忆森灵  阅读(292)  评论(0编辑  收藏  举报