为什么导出的EXCEL没有网格

Question

我用的是gridveiw控件。导出来的Excel表格没有网格
高手帮解决一下。

Answer 1

public void ExportToExcel(string FileType, string FileName) 
    { 
        Response.Charset = "GB2312"; 
        Response.ContentEncoding = System.Text.Encoding.UTF8; 
        Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8).ToString()); 
        Response.ContentType = FileType; 
        this.EnableViewState = false; 
        StringWriter tw = new StringWriter(); 
        HtmlTextWriter hw = new HtmlTextWriter(tw); 
        GridView1.RenderControl(hw); 
        Response.Output.Write(tw.ToString()); 
        Response.Flush(); 
        Response.End(); 
    } 
public override void VerifyRenderingInServerForm(Control control) 
    {     }

Answer 2

protected void Btn_ExportClick(object sender, EventArgs e){
string style = @"<style> .text { mso-number-format:\@; } </script> "; 
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GridView1.RenderControl(htw);
Response.Write(style); 
Response.Write(sw.ToString());
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{}