从DATAGRID在线导入EXCEL并打开

Posted on 2004-11-04 14:37 昕阅读(798) 评论(1) 编辑收藏所属分类: 工作有感

很多时候我们会在DATAGRID中使用控件及操作，这时导出数据就需要隐藏操作列。
例子代码如下：请注意颜色代码部分。
   dgQryAgioUser.Columns[8].Visible = false;
   dgQryAgioUser.Columns[9].Visible = false;
   Response.Clear();
   Response.Buffer= true;
   Response.Charset="GB2312";
   Response.AppendHeader("Content-Disposition","attachment;filename=NewFile.xls");
   Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
   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);
   this.dgQryAgioUser.RenderControl(oHtmlTextWriter);
   Response.Write(oStringWriter.ToString());
   Response.End();
   dgQryAgioUser.Columns[8].Visible = true;
   dgQryAgioUser.Columns[9].Visible = true;