将GridView导入到Excel和word(完全可实现)12.docVIP

1.将GridView导入到Excel和word 需要注意两个地方： 1.EnableEventValidation=false 必须加 2.下面这个事件必须加 public override void VerifyRenderingInServerForm(Control control)??? {??????? //base.VerifyRenderingInServerForm(control);??? } 在%@ Page Language=C# ...%中加上EnableEventValidation=false加了这个必须在导出前取消分页，否则只导出当前页，而不是整个gridview的数据。 在我的资源里有相应的原代码下载 %@ Page Language=C# AutoEventWireup=true CodeFile=excel.aspx.cs EnableEventValidation=false Inherits=将GridView导出到Excel_excel % !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN /TR/xhtml1/DTD/xhtml1-transitional.dtd html xmlns=/1999/xhtml head runat=server??? title将Gridview导出到Excel，Word/title/headbody??? form id=form1 runat=server??? div??????? asp:GridView ID=GridView1 runat=server AllowPaging=True AutoGenerateColumns=False??????????? CellPadding=4 DataKeyNames=stuid DataSourceID=SqlDataSource1 ForeColor=#333333??????????? GridLines=None??????????? FooterStyle BackColor=#5D7B9D Font-Bold=True ForeColor=White /??????????? Columns??????????????? asp:BoundField DataField=stuid HeaderText=编号 InsertVisible=False ReadOnly=True??????????????????? SortExpression=stuid /??????????????? asp:BoundField DataField=stuname HeaderText=姓名 SortExpression=stuname /??????????????? asp:CheckBoxField DataField=stusex HeaderText=性别 SortExpression=stusex /??????????????? asp:BoundField DataField=stuaddress HeaderText=地址 SortExpression=stuaddress /??????????????? asp:BoundField DataField=stuage HeaderText=年龄 SortExpression=stuage /??????????????? asp:BoundField DataField=stutuition HeaderText=学费 SortExpression=stutuition /??????????????? asp:BoundField DataField=stuaveragescore HeaderText=成绩 SortExpression=stuaveragescore /??????????? /Columns??????????? RowStyle BackColor=#F7F6F3 ForeColor=#333333 /??????????? EditRowStyle BackColor=#999999 /??????????? SelectedRowStyle BackColor=#E2DED6 Font-Bold=True ForeColor=#333333 /??????????? PagerStyle BackColor=#284775 ForeColor=White HorizontalAlign=Center /??????????? HeaderStyle BackColo