大家好,又见面了,我是你们的朋友全栈君。
![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
//
使用控件的RenderControl()方法生成HTML表格
![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
string
strName
=
“
HuaMingCe
“
;
Response.Clear();
Response.Buffer =
true
;
Response.Charset =
“
utf-8
“
;
Response.AppendHeader(“
Content-Disposition
“
,
“
attachment;filename=
“
+
strName
+
“
.xls
“
);
Response.ContentEncoding =
System.Text.Encoding.GetEncoding(
“
utf-8
“
);
//
设置输出流为简体中文
![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
Response.ContentType
=
“
application/ms-excel
“
;
//
设置输出文件类型为excel文件。
![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
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);
if
(GridViewMaster
!=
null
)
//
GridViewMaster 是GridView控件
![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
{
GridViewMaster.RenderControl(oHtmlTextWriter);//将服务器控件的内容输出
}
Response.Write(oStringWriter.ToString());
Response.End();![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
//
同时vs2005会报错“类型“ExGridView”的控件“GridViewMaster”必须放在具有 runat=server 的窗体标记内
![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
”![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
//
需要添加下面取消对GridViewMaster 控件验证的方法
![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
public
override
void
VerifyRenderingInServerForm(Control control)
![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
{
if (!control.GetType().Equals(GridViewMaster.GetType()))![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
{
base.VerifyRenderingInServerForm(control);
}
}![[转]使用控件的RenderControl()方法导出Excel](https://javaforall.net/wp-content/uploads/2020/11/2020110817443450.jpg)
转载于:https://www.cnblogs.com/yiki/archive/2007/11/11/955798.html
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/162064.html原文链接:https://javaforall.net
