求aspx中导出Excel文件详细步骤~

[copelis]

rt

[wuyq11]

gridview导出excel
打开excel模板，赋值到单元格

[copelis]

[Quote=引用 1 楼 wuyq11 的回复:]
gridview导出excel
打开excel模板，赋值到单元格
[/Quote]

有实例么...这样比较抽象...

[wuyq11]

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);
gv.RenderControl(htw);
Response.Write(style);
Response.Write(sw.ToString());
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{

}