把DataGrid中的数据出Execl,其中"身份证"这一字段在Excel中后面的几位都变为0了,请高手指教

[ljfwarrior]

我用的导出方法是:

public void DataGridToExcel(DataGrid grdTemp,DataTable dsTemp,string strTitle)
{
strTitle=HttpUtility.UrlEncode(strTitle.Trim(),System.Text.Encoding.UTF8); //编码转换
grdTemp.AllowPaging =false; //设置不能分页
grdTemp.DataSource =dsTemp ; //重新绑定
grdTemp.DataBind();
//常规导出方法
System.IO.StringWriter SW = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter HTW=new System.Web.UI.HtmlTextWriter(SW);
grdTemp.RenderControl(HTW);

//Page为要导出的对象,当前是Page,如果是DataGrid,DataList等都可以
Response.Buffer=true;
Response.Clear();
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/vnd.ms-excel";
//Response.ContentType是输出流的 HTTP MIME 类型
//Response.ContentType --- word文件
//application/vnd.ms-excel --- excel文件
//...
Response.Charset="utf-8";
Response.ContentEncoding=System.Text.Encoding.GetEncoding("utf-8");
Response.AddHeader("Content-Disposition", "attachment;filename="+strTitle+".xls");
//attachment --- 作为附件下载
//inline --- 在线打开
//filename如过是中文,则可以用
strTitle=HttpUtility.UrlEncode(strTitle,System.Text.Encoding.UTF8);
//进行进行编码,以解决文件名乱码的问题
Response.Write(SW.ToString());
Response.Flush();
Response.Close();
}


导出后身份证号码一字段都变成以下:
4.40682E+17
4.40682E+17
4.40682E+17
4.40682E+17
4.40682E+17
4.40682E+17


我把该列的格式转换为数字时,后面的几位都变为0了
440682198207312000
440682198207312000
440682198207312000
440682198207312000
440682198207312000
440682198207312000

请高手指教

[孟子E章]

http://dotnet.aspx.cc/article/8A4CBF47-B888-4832-3389-ED3A3A3C8AAB/read.aspx

http://dotnet.aspx.cc/Exam/OutPutExcel.aspx

[孟子E章]

e.Item.Cells[0].Attributes.Add("style","vnd.ms-excel.numberformat:@");
即可

[nimeide1234567890]

<%@ Page language="c#" AutoEventWireup="true" %>
<script runat="server">
void Page_Load(object sender, System.EventArgs e)
{
string data1 = "000000001";
long data2 = 123456789123456789;
System.IO.StringWriter sw = new System.IO.StringWriter();
sw.WriteLine("原数字1\t转换后数字1\t原数字2\t转换数字2");
for(int i= 0;i<10;i++)
{
sw.WriteLine(data1 +"\t" + "=\"" + data1 + "\"\t" + data2 +"\t" + "=\"" + data2.ToString() + "\"");
}
sw.Close();
Response.Buffer= true;
Response.Charset="";
Response.AppendHeader("Content-Disposition","attachment;filename=aa.xls");
Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
Response.Write(sw);
Response.End();

}
</script>

[shalen520]

mark

[ljfwarrior]

谢谢 net_lover(【孟子E章】) OK拉!!哈哈..谢谢