将GridView导入到Excel和word完全可实现.docx
《将GridView导入到Excel和word完全可实现.docx》由会员分享,可在线阅读,更多相关《将GridView导入到Excel和word完全可实现.docx(11页珍藏版)》请在冰点文库上搜索。
将GridView导入到Excel和word完全可实现
1.将GridView导入到Excel和word
需要注意两个地方:
1.EnableEventValidation="false"必须加
2.下面这个事件必须加
publicoverridevoidVerifyRenderingInServerForm(Controlcontrol)
{
//base.VerifyRenderingInServerForm(control);
}
3、若有分页功能
在<%@PageLanguage="C#"...%>中加上EnableEventValidation="false"
加了这个必须在导出前取消分页,否则只导出当前页,而不是整个gridview的数据。
在我的资源里有相应的原代码下载
<%@PageLanguage="C#"AutoEventWireup="true"CodeFile="excel.aspx.cs"EnableEventValidation="false"Inherits="将GridView导出到Excel_excel"%>
DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN""http:
//www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
//www.w3.org/1999/xhtml">
将Gridview导出到Excel,Word
GridViewID="GridView1"runat="server"AllowPaging="True"AutoGenerateColumns="False"
CellPadding="4"DataKeyNames="stuid"DataSourceID="SqlDataSource1"ForeColor="#333333"
GridLines="None">
BoundFieldDataField="stuid"HeaderText="编号"InsertVisible="False"ReadOnly="True"
SortExpression="stuid"/>
BoundFieldDataField="stuname"HeaderText="姓名"SortExpression="stuname"/>
CheckBoxFieldDataField="stusex"HeaderText="性别"SortExpression="stusex"/>
BoundFieldDataField="stuaddress"HeaderText="地址"SortExpression="stuaddress"/>
BoundFieldDataField="stuage"HeaderText="年龄"SortExpression="stuage"/>
BoundFieldDataField="stutuition"HeaderText="学费"SortExpression="stutuition"/>
BoundFieldDataField="stuaveragescore"HeaderText="成绩"SortExpression="stuaveragescore"/>
GridView>
SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ConnectionStrings:
myTestGridViewConnectionString%>"
SelectCommand="SELECT*FROM[stu]">
SqlDataSource>
ButtonID="Button1"runat="server"Text="导出到Excel"OnClick="Button1_Click"/>
ButtonID="Button2"runat="server"OnClick="Button2_Click"Text="导出到Word"Width="108px"/>