GridView导出Excel 在线等，很急

风2013 2010-12-08 02:50:57

GridView 导出excel 为甚么在2003中打开没有问题，在2007中打开包格式错误
public static void Export ( GridView gv, bool b ) {
HttpContext.Current.Response.Clear ();
HttpContext.Current.Response.Charset = "utf-8";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
HttpContext.Current.Response.AddHeader (
"content-disposition", "attachment; filename=ss.xls" );
HttpContext.Current.Response.ContentType = "application/vnd.xls";
HttpContext.Current.Response.Write("<meta http-equiv=Content-Type content=text/html;charset=utf-8>");

using ( StringWriter sw = new StringWriter () ) {
using ( HtmlTextWriter htw = new HtmlTextWriter ( sw ) ) {
// Create a form to contain the grid 创建一个表格，包含网格
Table table = new Table ();
if ( b ) {
table.GridLines = gv.GridLines;
}
// add the header row to the table 标题行添加到表
if ( gv.HeaderRow != null ) {
GridViewExportUtil.PrepareControlForExport ( gv.HeaderRow );
table.Rows.Add ( gv.HeaderRow );
}

// add each of the data rows to the table 添加每一行数据到表
foreach ( GridViewRow row in gv.Rows ) {
GridViewExportUtil.PrepareControlForExport ( row );
table.Rows.Add ( row );
}

// add the footer row to the table 添加页脚行到表
if ( gv.FooterRow != null ) {
GridViewExportUtil.PrepareControlForExport ( gv.FooterRow );
table.Rows.Add ( gv.FooterRow );
}

try {
//屏蔽第一列
for ( int i = 0; i < table.Rows.Count; i++ ) {
table.Rows[ i ].Cells[ 10 ].Visible = false;
table.Rows[ i ].Cells[ 9 ].Visible = false;
//table.Rows[ i ].Cells[ 9 ].Visible = false;
table.Rows[ i ].Cells[ 6 ].Visible = false;
table.Rows[ i ].Cells[ 0 ].Visible = false;
}
}
catch ( Exception ) {
;
}

// render the table into the htmlwriter 渲染到htmlwriter表
table.RenderControl ( htw );

// render the htmlwriter into the response 渲染到响应的htmlwriter
HttpContext.Current.Response.Write ( sw.ToString () );
HttpContext.Current.Response.End ();
}

这是我的代码

请高手指教

...全文