在线等~~急急... Excel导出数据 数据少时 不会乱码 数据多时乱码...

[TimLeaf]

这是开始的导出的代码...

Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/octet-stream";
Response.AddHeader("Content-Disposition","attachment; filename=\"" + HttpUtility.UrlEncode("AggregateTable.xls", System.Text.Encoding.UTF8) + "\";");
Response.Charset = "SHIFT-JIS";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("SHIFT-JIS");

下面就是：

Response.Write("<TABLE>");
...

在单独页面里面生成excel...然后发送到客户端...

为什么...
数据少时 不会乱码 数据多时乱码...

[wuyq11]

加
System.Globalization.CultureInfo ctinfo = new System.Globalization.CultureInfo( "zh-CN ", true);
Response.Charset = "gb2312 ";
看下
参考
http://www.cnblogs.com/HQT/archive/2005/08/05/208027.aspx

[RexZheng]

学习

[criedshy]

Response.Charset = "SHIFT-JIS";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("SHIFT-JIS");


都改成UTF-8

Response.Charset = "UTF-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");

[gengwanshanreally]

learn!

[xiaoyuzi]

我是先生成一个excel文件，然后发送到客户端
// Create excel worksheet
ExcelServer.ExcelEnterpriseProject ecep = new ExcelServer.ExcelEnterpriseProject();
string filepath = Server.MapPath("~/ExcelTemplateStore/ExcelEnterpriseProject.xls");
ecep.TemplateFile = filepath;
ecep.CreateWorkbook();

// Add records
...
ecep.DataSource = lst;
...
ecep.AddRecords();

// Format cells
ecep.Format();

string sGenName = "CSDN社区.xls";
System.IO.FileStream fs = null;
fs = System.IO.File.Open(filepath, System.IO.FileMode.Open);
byte[] btFile = new byte[fs.Length];
fs.Read(btFile, 0, Convert.ToInt32(fs.Length));
fs.Close();

// File name with chinese not more than 16?
Response.AddHeader("Content-disposition", "attachment; filename=" + HttpUtility.UrlEncode(System.Text.Encoding.UTF8.GetBytes(sGenName)));
Response.ContentType = "application/vnd.ms-excel";
Response.BinaryWrite(btFile);
Response.End();

[mengxj85]

学习

[yanlongwuhui]

关注

[yanxiguang_0]

我是数据少的时候出现乱码，以前同事用这句话：Response.Charset = "gb2312";可以，但我不行，后来改成下面这句可以了：Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");