ASP.NET Grid数据导出到Excel

来源：互联网发布：上海博物馆淘宝编辑：程序博客网时间：2024/04/26 07:27

很简单的原理，话不多说，请看源码！

源码中的QGridViewMachine就是我们要将其数据导入到Excel中的Grid

        //匯出Excel        public void ToExcel()        {   //对各列的属性做相应设置              QGridViewMachine.Columns[4].Visible = false;                   //checkbox隐藏掉              QGridViewMachine.Columns[5].ItemStyle.Width = Unit.Pixel(80);  //将checkbox的checked属性转为“是”与“否”显示的列              QGridViewMachine.Columns[5].HeaderStyle.Width = Unit.Pixel(80);            QGridViewMachine.Columns[8].Visible = false;            QGridViewMachine.Columns[9].Visible = false;            QGridViewMachine.Columns[10].Visible = false;            //简单说就是把QGridViewMachine的内容写到sb中              StringBuilder sb = new StringBuilder();             StringWriter sw = new StringWriter(sb);             HtmlTextWriter htw = new HtmlTextWriter(sw);             QGridViewMachine.RenderControl(htw);             Response.Clear();             Response.Buffer = true;             Response.ContentType = "application/vnd.ms-excel";             Response.AddHeader("Content-Disposition", "attachment;filename=data.xls");             Response.Charset = "UTF-8";             Response.ContentEncoding = Encoding.Default;             Response.Write(sb.ToString());            Response.Flush();            Response.End();         }