这样输出的csv文件中单元格的数据“0015”变成“15”了,我在前面加上‘符号后生成的数据成了“‘0015” 很郁闷,大家是怎么做的呢?string strIsZero = string.Empty;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
strData.Append((i+1).ToString());
strData.Append(",");
strData.Append(ds.Tables[0].Rows[i]["Account"].ToString());
strData.Append("\n");
} strTemp = string.Format("attachment;filename={0}", Server.UrlEncode(""+ this.ddlCla.SelectedItem.Text +"成绩导入模板.csv"));
Response.ContentEncoding = Encoding.GetEncoding("GB2312");
Response.ClearHeaders();
Response.AppendHeader("Content-disposition", strTemp);
Response.Write(strData);
Response.End();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
strData.Append((i+1).ToString());
strData.Append(",");
strData.Append(ds.Tables[0].Rows[i]["Account"].ToString());
strData.Append("\n");
} strTemp = string.Format("attachment;filename={0}", Server.UrlEncode(""+ this.ddlCla.SelectedItem.Text +"成绩导入模板.csv"));
Response.ContentEncoding = Encoding.GetEncoding("GB2312");
Response.ClearHeaders();
Response.AppendHeader("Content-disposition", strTemp);
Response.Write(strData);
Response.End();
或者对数字进行格式化:
strData.Append(ds.Tables[0].Rows[i]["Account"].ToString("0000"))