好比gridview中显示3行3列，我想要的是导出到excel后显示成5行3列，并且设置打印的默认纸张为A3
------解决方案--------------------------------------------------------
例子，直接拷贝测试
- HTML code
<%@ Page Language="C#" AutoEventWireup="true" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><script runat="server"> public System.Data.DataTable GetData() { System.Data.DataTable dataTable1 = new System.Data.DataTable("BlogUser"); dataTable1.Columns.Add(new System.Data.DataColumn("UserId", typeof(System.Int32))); dataTable1.Columns.Add(new System.Data.DataColumn("Title", typeof(System.String))); dataTable1.Columns.Add(new System.Data.DataColumn("Test", typeof(System.String))); dataTable1.Rows.Add(new Object[] { 11, 22, 33 }); dataTable1.Rows.Add(new Object[] { 111, 2222, 3333 }); dataTable1.Rows.Add(new Object[] { 11111, 22222, 33333 }); return dataTable1; } protected void Page_Load(object sender, EventArgs e) { GridView1.DataSource = GetData(); GridView1.DataBind(); } protected void Button1_Click(object sender, EventArgs e) { Response.ClearContent(); Response.BufferOutput = true; Response.Charset = "utf-8"; Response.ContentType = "application/ms-excel"; Response.AddHeader("Content-Transfer-Encoding", "binary"); Response.ContentEncoding = System.Text.Encoding.UTF8; String FileName = "孟宪会Excel表格测试"; if (!String.IsNullOrEmpty(Request.UserAgent)) { // firefox 里面文件名无需编码。 if (!(Request.UserAgent.IndexOf("Firefox") > -1 && Request.UserAgent.IndexOf("Gecko") > -1)) { FileName = Server.UrlEncode(FileName); } } Response.AppendHeader("Content-Disposition", "attachment;filename=" + FileName + ".xls"); Response.Write("<?xml version='1.0'?><?mso-application progid='Excel.Sheet'?>"); Response.Write(@"<Workbook xmlns='urn:schemas-microsoft-com:office:spreadsheet' xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:x='urn:schemas-microsoft-com:office:excel' xmlns:ss='urn:schemas-microsoft-com:office:spreadsheet' xmlns:html='http://www.w3.org/TR/REC-html40'>"); Response.Write(@"<DocumentProperties xmlns='urn:schemas-microsoft-com:office:office'>"); Response.Write(@"<Author>孟宪会</Author><LastAuthor>孟子E章</LastAuthor> <Created>2010-09-08T14:07:11Z</Created><Company>mxh</Company><Version>1990</Version>"); Response.Write("</DocumentProperties>"); Response.Write(@"<Styles><Style ss:ID='Default' ss:Name='Normal'><Alignment ss:Vertical='Center'/> <Borders/><Font ss:FontName='宋体' x:CharSet='134' ss:Size='12'/><Interior/><NumberFormat/><Protection/></Style>"); //定义标题样式 Response.Write(@"<Style ss:ID='Header'><Borders><Border ss:Position='Bottom' ss:LineStyle='Continuous' ss:Weight='1'/> <Border ss:Position='Left' ss:LineStyle='Continuous' ss:Weight='1'/> <Border ss:Position='Right' ss:LineStyle='Continuous' ss:Weight='1'/> <Border ss:Position='Top' ss:LineStyle='Continuous' ss:Weight='1'/></Borders> <Font ss:FontName='宋体' x:CharSet='134' ss:Size='18' ss:Color='#FF0000' ss:Bold='1'/></Style>"); //定义边框 Response.Write(@"<Style ss:ID='border'><NumberFormat ss:Format='@'/><Borders> <Border ss:Position='Bottom' ss:LineStyle='Continuous' ss:Weight='1'/> <Border ss:Position='Left' ss:LineStyle='Continuous' ss:Weight='1'/> <Border ss:Position='Right' ss:LineStyle='Continuous' ss:Weight='1'/> <Border ss:Position='Top' ss:LineStyle='Continuous' ss:Weight='1'/></Borders></Style>"); Response.Write(@"<Style ss:ID=""s23""><Borders><Border ss:Position='Bottom' ss:LineStyle='Continuous' ss:Weight='1'/> <Border ss:Position='Left' ss:LineStyle='Continuous' ss:Weight='1'/> <Border ss:Position='Right' ss:LineStyle='Continuous' ss:Weight='1'/> <Border ss:Position='Top' ss:LineStyle='Continuous' ss:Weight='1'/></Borders><Alignment ss:Horizontal=""Right"" ss:Vertical=""Center""/></Style>"); Response.Write(@"<Style ss:ID='HeaderRight'><Borders><Border ss:Position='Bottom' ss:LineStyle='Continuous' ss:Weight='1'/> <Border ss:Position='Left' ss:LineStyle='Continuous' ss:Weight='1'/> <Border ss:Position='Right' ss:LineStyle='Continuous' ss:Weight='1'/> <Border ss:Position='Top' ss:LineStyle='Continuous' ss:Weight='1'/></Borders> <Font ss:FontName='宋体' x:CharSet='134' ss:Size='18' ss:Color='#FF0000' ss:Bold='1'/><Alignment ss:Horizontal=""Center"" ss:Vertical=""Center""/></Style>"); Response.Write("</Styles>"); Response.Write("<Worksheet ss:Name='Sheet1'>"); Response.Write("<Table x:FullColumns='1' x:FullRows='1'>"); //输出标题 Response.Write("<Row><Cell ss:MergeAcross='2' ss:StyleID='HeaderRight'><Data ss:Type='String'>标题</Data></Cell></Row>"); Response.Write("<Row ss:AutoFitHeight='1'>"); Response.Write("<Cell ss:StyleID='Header'><Data ss:Type='String'>列1</Data></Cell>"); Response.Write("<Cell ss:StyleID='Header'><Data ss:Type='String'>列2</Data></Cell>"); Response.Write("<Cell ss:StyleID='Header'><Data ss:Type='String'>列3</Data></Cell>"); Response.Write("\r\n</Row>"); System.Data.DataTable dt = this.GetData(); for (int j = 0; j < dt.Rows.Count; j++) { Response.Write("<Row>"); for (int c = 0; c < 3; c++) { //对于数字，采用Number数字类型 if (c > 1) { Response.Write("<Cell ss:StyleID='border'><Data ss:Type='Number'>" + dt.Rows[j][c].ToString() + "</Data></Cell>"); } else { Response.Write("<Cell ss:StyleID='border'><Data ss:Type='String'>" + dt.Rows[j][c].ToString() + "</Data></Cell>"); } } Response.Write("</Row>"); } Response.Write("<Row><Cell ss:MergeAcross='2' ss:StyleID='s23'><Data ss:Type='String'>2010年9月8日</Data></Cell></Row>"); Response.Write("</Table>"); Response.Write("</Worksheet>"); Response.Flush(); Response.Write("</Workbook>"); Response.End(); }</script><html xmlns="http://www.w3.org/1999/xhtml"><head id="Head1" runat="server"> <title>无标题页</title></head><body> <form id="form1" runat="server"> <asp:GridView ID="GridView1" runat="server"> </asp:GridView> <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="导出" /> </form></body></html>