首页 > 代码库 > Asp.net中由DataSet数据类型导出Excel

Asp.net中由DataSet数据类型导出Excel

今天要做一个功能 导出录取学生信息 费了半天劲结果被老师教育了一番 好了不抱怨了

DataSet数据类型导出Excel

好了不说了上源码

  try {       

               System.Web.HttpContext curContext = System.Web.HttpContext.Current;
         

              DataSet dsExcel = xqgl.Select_DCXSXXALL();                

               DataGrid dg = new DataGrid();               

               dg.DataSource = dsExcel;                

              dg.DataBind();

              for (int i = 0; i < dg.Items.Count; i++) {                    

                        dg.Items[i].Cells[0].Attributes.Add("style", "vnd.ms-excel.numberformat:@");                    

                        dg.Items[i].Cells[1].Attributes.Add("style", "vnd.ms-excel.numberformat:@");                    

                       dg.Items[i].Cells[2].Attributes.Add("style", "vnd.ms-excel.numberformat:@");                   

                       dg.Items[i].Cells[3].Attributes.Add("style", "vnd.ms-excel.numberformat:@");                

                }

                curContext .Response.Clear();                

              curContext . Response.Buffer = true;                

               curContext .Response.Charset = "GB2312";                

               curContext .Response.AppendHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode(myXianQuState.XianQuMC+"优质录取学                 生.xls"));                

               curContext .Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文                

               curContext .Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。                

                this.EnableViewState = false;                

               System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);                

                System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);                

                System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);               

                dg.RenderControl(oHtmlTextWriter);                

                curContext .Response.Write(oStringWriter.ToString());                

                curContext .Response.End();            

                }            

               catch (Exception ex)  {             

                            string msg = ex.Message;                

                             curContext .Response.Write("<script>javascript:alert(‘导出失败,请重试!‘)</script>");               

                              return;            

                }