protected void Button1_Click(object sender, EventArgs e)
{
string style = @"<style> .text { mso-number-format:\@; } </style> ";
string name = bj + "_" + zy + ".xls";//文件名字
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename="+HttpUtility.UrlEncode(name,System.Text.Encoding.UTF8));
Response.ContentType = "application/ms-excel";
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
GridView1.RenderControl(htw);
Response.Write(style);
Response.Write(sw.ToString());
Response.End();
}
protected void Gridview_RowDataBound(object sender, GridViewRowEventArgs e)
{
e.Row.Cells[1].Attributes.Add("class", "text");
e.Row.Cells[0].Attributes.Add("class", "text");
}
-----------------------------------程序導出excel代碼-------------------------------------------
請問(wèn)導出的時(shí)候為什么沒(méi)有調用Gridview_RowDataBound（）這個(gè)函數呢？？
網(wǎng)上的解決方案我都已經(jīng)試過(guò)了，請給出可用的方案。謝謝
Ps：第一列是學(xué)號，開(kāi)頭是0。要求是保留前導零即可。。。。
要求：要么給出此代碼得修改方案，要么給出真實(shí)可行的代碼。
請勿灌水，謝謝，，急??！
public override void VerifyRenderingInServerForm(Control control)
{
}
此函數已經(jīng)添加。。。
/// <summary>
/// 把Gridview中數據導入到Excel中
/// </summary>
/// <param name="gv">需要導出數據的Gridview</param>
/// <param name="dt">Gridview的數據源</param>
/// <param name="strFileName">默認的導出Excel的文件名</param>
/// <param name="bolPart">全部還是部分導出到Excel.部分：true. 全部：false</param>
public static void ConvertToExcel(GridView gv, DataTable dt, string strFileName, bool bolPart)
{
gv.AllowPaging = bolPart;//設置導出數據是全部還是部分
gv.DataSource = dt;
gv.DataBind();
//循環(huán)遍歷GridView中的每一列
for (int i = 0; i < gv.Columns.Count; i++) //設置每個(gè)單元格
{
gv.Columns[i].ItemStyle.HorizontalAlign = HorizontalAlign.Left;
for (int j = 0; j < gv.Rows.Count; j++)
{
gv.Rows[j].Cells[i].Attributes.Add("style", "vnd.ms-excel.numberformat:@;");
}
}
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Charset = "GB2312";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF7;
strFileName += ".xls";
HttpContext.Current.Response.ContentType = "application/ms-excel";
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlPathEncode(strFileName));//設置默認文件名
HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
//預防出現控件必須放在具有 runat=server 的窗體標記內的錯誤
Page page = new Page();
HtmlForm form = new HtmlForm();
gv.EnableViewState = false;
page.EnableEventValidation = false;
page.DesignerInitialize();
page.Controls.Add(form);
form.Controls.Add(gv);
page.RenderControl(htw);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
聯(lián)系客服
