返回首页

您好所有,

我用下面的代码,出口值在Excel 2007网格。
我必须在GridView内部形式标记错误。
据我可以看到它里面的表单标签。
我缺少的东西在这里吗?

Response.Clear();

            Response.Buffer = true;

            Response.ContentType = "application/vnd.ms-excel";

            Response.AddHeader("content-disposition", "attachment;filename=MyFiles.xlsx");

            Response.Charset = "";

            this.EnableViewState = false;

 

            System.IO.StringWriter sw = new System.IO.StringWriter();

            System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);

 

            grdExcel.RenderControl(htw);

 

            Response.Write(sw.ToString());

            Response.End();

{C}
谢谢。

回答

评论会员:游客 时间:2012/02/06
|PrahladMca:。本类ü可以帮助在Excel.Only出口网格视图数据传递2个参数的文件名和网格实例codeprelang="c#"spanclass="code-keyword"using/spanSystem;spanclass="code-keyword"using/spanSystem.Collections.Generic;spanclass="code-keyword"using/spanSystem.Web;spanclass="code-keyword"using/spanSystem.Web.UI;spanclass="code-keyword"using/spanSystem.Web.UI.WebControls;spanclass="code-keyword"using/spanSystem.IO;spanclass="code-keyword"using/spaniTextSharp.text.html;spanclass="code-keyword"using/spaniTextSharp.text.html.simpleparser;spanclass="code-keyword"using/spaniTextSharp.text;spanclass="code-keyword"using/spaniTextSharp.text.pdf;   spanclass="code-SummaryComment"////spanspanclass="code-comment"spanclass="code-SummaryComment"</spanspanclass="code-SummaryComment"summary/spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"Summary/spanspanclass="code-SummaryComment"description/spanspanclass="code-SummaryComment"for/spanspanclass="code-SummaryComment"ExcelExport/spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"</spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"summary/spanspanclass="code-SummaryComment"public/spanspanclass="code-SummaryComment"class/spanspanclass="code-SummaryComment"ExcelExport/spanspanclass="code-SummaryComment"{/spanspanclass="code-SummaryComment"public/spanspanclass="code-SummaryComment"static/spanspanclass="code-SummaryComment"void/spanspanclass="code-SummaryComment"Export(string/spanspanclass="code-SummaryComment"fileName,/spanspanclass="code-SummaryComment"GridView/spanspanclass="code-SummaryComment"gv)/spanspanclass="code-SummaryComment"{/spanspanclass="code-SummaryComment"HttpContext.Current.Response.Clear();/spanspanclass="code-SummaryComment"HttpContext.Current.Response.AddHeader(/spanspanclass="code-SummaryComment""content-disposition",/spanspanclass="code-SummaryComment"string.Format("attachment;filename={0}",/spanspanclass="code-SummaryComment"fileName));/spanspanclass="code-SummaryComment"HttpContext.Current.Response.ContentType/spanspanclass="code-SummaryComment"=/spanspanclass="code-SummaryComment""application/spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"ms-excel";/spanspanclass="code-SummaryComment"using/spanspanclass="code-SummaryComment"(StringWriter/spanspanclass="code-SummaryComment"sw/spanspanclass="code-SummaryComment"=/spanspanclass="code-SummaryComment"new/spanspanclass="code-SummaryComment"StringWriter())/spanspanclass="code-SummaryComment"{/spanspanclass="code-SummaryComment"using/spanspanclass="code-SummaryComment"(HtmlTextWriter/spanspanclass="code-SummaryComment"htw/spanspanclass="code-SummaryComment"=/spanspanclass="code-SummaryComment"new/spanspanclass="code-SummaryComment"HtmlTextWriter(sw))/spanspanclass="code-SummaryComment"{/spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"Create/spanspanclass="code-SummaryComment"a/spanspanclass="code-SummaryComment"table/spanspanclass="code-SummaryComment"to/spanspanclass="code-SummaryComment"contain/spanspanclass="code-SummaryComment"the/spanspanclass="code-SummaryComment"grid/spanspanclass="code-SummaryComment"Table/spanspanclass="code-SummaryComment"table/spanspanclass="code-SummaryComment"=/spanspanclass="code-SummaryComment"new/spanspanclass="code-SummaryComment"Table();/spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"include/spanspanclass="code-SummaryComment"the/spanspanclass="code-SummaryComment"gridline/spanspanclass="code-SummaryComment"settings/spanspanclass="code-SummaryComment"table.GridLines/spanspanclass="code-SummaryComment"=/spanspanclass="code-SummaryComment"gv.GridLines;/spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"add/spanspanclass="code-SummaryComment"the/spanspanclass="code-SummaryComment"header/spanspanclass="code-SummaryComment"row/spanspanclass="code-SummaryComment"to/spanspanclass="code-SummaryComment"the/spanspanclass="code-SummaryComment"table/spanspanclass="code-SummaryComment"if/spanspanclass="code-SummaryComment"(gv.HeaderRow/spanspanclass="code-SummaryComment"!=/spanspanclass="code-SummaryComment"null)/spanspanclass="code-SummaryComment"{/spanspanclass="code-SummaryComment"ExcelExport.PrepareControlForExport(gv.HeaderRow);/spanspanclass="code-SummaryComment"table.Rows.Add(gv.HeaderRow);/spanspanclass="code-SummaryComment"}/spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"add/spanspanclass="code-SummaryComment"each/spanspanclass="code-SummaryComment"of/spanspanclass="code-SummaryComment"the/spanspanclass="code-SummaryComment"data/spanspanclass="code-SummaryComment"rows/spanspanclass="code-SummaryComment"to/spanspanclass="code-SummaryComment"the/spanspanclass="code-SummaryComment"table/spanspanclass="code-SummaryComment"foreach/spanspanclass="code-SummaryComment"(GridViewRow/spanspanclass="code-SummaryComment"row/spanspanclass="code-SummaryComment"in/spanspanclass="code-SummaryComment"gv.Rows)/spanspanclass="code-SummaryComment"{/spanspanclass="code-SummaryComment"ExcelExport.PrepareControlForExport(row);/spanspanclass="code-SummaryComment"table.Rows.Add(row);/spanspanclass="code-SummaryComment"}/spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"add/spanspanclass="code-SummaryComment"the/spanspanclass="code-SummaryComment"footer/spanspanclass="code-SummaryComment"row/spanspanclass="code-SummaryComment"to/spanspanclass="code-SummaryComment"the/spanspanclass="code-SummaryComment"table/spanspanclass="code-SummaryComment"if/spanspanclass="code-SummaryComment"(gv.FooterRow/spanspanclass="code-SummaryComment"!=/spanspanclass="code-SummaryComment"null)/spanspanclass="code-SummaryComment"{/spanspanclass="code-SummaryComment"ExcelExport.PrepareControlForExport(gv.FooterRow);/spanspanclass="code-SummaryComment"table.Rows.Add(gv.FooterRow);/spanspanclass="code-SummaryComment"}/spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"render/spanspanclass="code-SummaryComment"the/spanspanclass="code-SummaryComment"table/spanspanclass="code-SummaryComment"into/spanspanclass="code-SummaryComment"the/spanspanclass="code-SummaryComment"htmlwriter/spanspanclass="code-SummaryComment"table.RenderControl(htw);/spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"render/spanspanclass="code-SummaryComment"the/spanspanclass="code-SummaryComment"htmlwriter/spanspanclass="code-SummaryComment"into/spanspanclass="code-SummaryComment"the/spanspanclass="code-SummaryComment"response/spanspanclass="code-SummaryComment"HttpContext.Current.Response.Write(sw.ToString());/spanspanclass="code-SummaryComment"HttpContext.Current.Response.End();/spanspanclass="code-SummaryComment"}/spanspanclass="code-SummaryComment"}/spanspanclass="code-SummaryComment"}/spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"<summary/spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"Replace/spanspanclass="code-SummaryComment"any/spanspanclass="code-SummaryComment"of/spanspanclass="code-SummaryComment"the/spanspanclass="code-SummaryComment"contained/spanspanclass="code-SummaryComment"controls/spanspanclass="code-SummaryComment"with/spanspanclass="code-SummaryComment"literals/spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"</spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"summary/spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"<param/spanspanclass="code-SummaryComment"name="control"</spanspanclass="code-SummaryComment"//spanspanclass="code-SummaryComment"param/spanspanclass="code-SummaryComment"private/spanspanclass="code-SummaryComment"static/spanspanclass="code-SummaryComment"void/spanspanclass="code-SummaryComment"PrepareControlForExport(Control/spanspanclass="code-SummaryComment"control)/spanspanclass="code-SummaryComment"{/spanspanclass="code-SummaryComment"for/spanspanclass="code-SummaryComment"(int/spanspanclass="code-SummaryComment"i/spanspanclass="code-SummaryComment"=/spanspanclass="code-SummaryComment"0;/spanspanclass="code-SummaryComment"i/spanspanclass="code-SummaryComment"</spanspanclass="code-SummaryComment"control.Controls.Count;/spanspanclass="code-SummaryComment"i++)/spanspanclass="code-SummaryComment"{/spanspanclass="code-SummaryComment"Control/spanspanclass="code-SummaryComment"current/spanspanclass="code-SummaryComment"=/spanspanclass="code-SummaryComment"control.Controls[i];/spanspanclass="code-SummaryComment"if/spanspanclass="code-SummaryComment"(current/spanspanclass="code-SummaryComment"is/spanspanclass="code-SummaryComment"LinkButton)/spanspanclass="code-SummaryComment"{/spanspanclass="code-SummaryComment"control.Controls.Remove(current);/spanspanclass="code-SummaryComment"control.Controls.AddAt(i,/spanspanclass="code-SummaryComment"new/spanspanclass="code-SummaryComment"LiteralControl((current/spanspanclass="code-SummaryComment"as/spanspanclass="code-SummaryComment"LinkButton).Text));/spanspanclass="code-SummaryComment"}/spanspanclass="code-SummaryComment"else/spanspanclass="code-SummaryComment"if/spanspanclass="code-SummaryComment"(current/spanspanclass="code-SummaryComment"is/spanspanclass="code-SummaryComment"ImageButton)/spanspanclass="code-SummaryComment"{/spanspanclass="code-SummaryComment"control.Controls.Remove(current);/spanspanclass="code-SummaryComment"control.Controls.AddAt(i,/spanspanclass="code-SummaryComment"new/spanspanclass="code-SummaryComment"LiteralControl((current/spanspanclass="code-SummaryComment"as/spanspanclass="code-SummaryComment"ImageButton).AlternateText));/spanspanclass="code-SummaryComment"}/spanspanclass="code-SummaryComment"else/spanspanclass="code-SummaryComment"if/spanspanclass="code-SummaryComment"(current/spanspanclass="code-SummaryComment"is/spanspanclass="code-SummaryComment"HyperLink)/spanspanclass="code-SummaryComment"{/spanspanclass="code-SummaryComment"control.Controls.Remove(current);/spanspanclass="code-SummaryComment"control.Controls.AddAt(i,/spanspanclass="code-SummaryComment"new/spanspanclass="code-SummaryComment"LiteralControl((current/spanspanclass="code-SummaryComment"as/spanspanclass="code-SummaryComment"HyperLink).Text));/spanspanclass="code-SummaryComment"}/spanspanclass="code-SummaryComment"else/spanspanclass="code-SummaryComment"if/spanspanclass="code-SummaryComment"(current/spanspanclass="code-SummaryComment"is/spanspanclass="code-SummaryComment"DropDownList)/spanspanclass="code-SummaryComment"{/spanspanclass="code-SummaryComment"control.Controls.Remove(current);/spanspanclass="code-SummaryComment"control.Controls.AddAt(i,/spanspanclass="code-SummaryComment"new/spanspanclass="code-SummaryComment"LiteralControl((current/spanspanclass="code-SummaryComment"as/spanspanclass="code-SummaryComment"DropDownList).SelectedItem.Text));/spanspanclass="code-SummaryComment"}/spanspanclass="code-SummaryComment"else/spanspanclass="code-SummaryComment"if/spanspanclass="code-SummaryComment"(current/spanspanclass="code-SummaryComment"is/spanspanclass="code-SummaryComment"CheckBox)/spanspanclass="code-SummaryComment"{/spanspanclass="code-SummaryComment"control.Controls.Remove(current);/spanspanclass="code-SummaryComment"control.Controls.AddAt(i,/spanspanclass="code-SummaryComment"new/spanspanclass="code-SummaryComment"LiteralControl((current/spanspanclass="code-SummaryComment"as/spanspanclass="code-SummaryComment"CheckBox).Checked/spanspanclass="code-SummaryComment"?/spanspanclass="code-SummaryComment""True"/spanspanclass="code-SummaryComment":/spanspanclass="code-SummaryComment""False"));/spanspanclass="code-SummaryComment"}/spanspanclass="code-SummaryComment"if/spanspanclass="code-SummaryComment"(current.HasControls())/spanspanclass="code-SummaryComment"{/spanspanclass="code-SummaryComment"ExcelExport.PrepareControlForExport(current);/spanspanclass="code-SummaryComment"}/spanspanclass="code-SummaryComment"}/spanspanclass="code-SummaryComment"}/spanspanclass="code-SummaryComment"}/span/span/pre/code的
。乌代・辛格
评论会员:游客 时间:2012/02/06
您好,这些尝试,imgsrc=http://www.orcode.com/img/ico/smiley_smile.gifimgsrc=]
阿努普达斯古普塔(asteranup)的:检查这些了:

{A2}

{A3的}
希望它可以帮助{S0}:乌代・辛格
评论会员:游客 时间:2012/02/06
你可以使用这个工具{A4纸}]
koolprasad2003
评论会员:游客 时间:2012/02/06
{C3的}按照这个格式,再试一次