datagrid gridview 倒出数据为 excel 时,编号问题

        把gridview  中的数据倒出 为 excel时 (编号长时在 excel 中会变成科学计数)


//倒出按钮  

 
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);

        gvUsers.RenderControl(htw);
        
// Style is added dynamically
        Response.Write(style); 
        Response.Write(sw.ToString());
        Response.End();
    }


 
//行绑定事件
 protected void gvUsers_RowDataBound(object sender, GridViewRowEventArgs e)
    
{      

        
if (e.Row.RowType == DataControlRowType.DataRow)
        
{
            e.Row.Cells[
4].Attributes.Add("class""text");  //主要是这
        }

    }



具体可以看这
http://gridviewguy.com/ArticleDetails.aspx?articleID=197

posted on 2006-08-23 14:40  gwazy  阅读(4915)  评论(1编辑  收藏  举报

导航