c#从sqlserver数据库导出的csv文件excel打开为乱码

[tigerhunter83]

从网上查了，用vs 2010开发环境，sql server 2000,C#写的文件编码为utf-8，而excel 2007只支持ansi编码，用ultraedit打开文件并保存为ansi编码，excel打开就正常了，有什么办法可以编程解决这个问题？比如设置c#写的文件的编码方式，请高手指点。

[發糞塗牆]

C#应该可以设置编码格式的吧。不过你最好到.net专区问问好。我不记得C#怎么写了

[IEEE_China]

试试

    private static void DownLoadExcel(string path,Page  page)
        {
	System.IO.FileInfo file = new System.IO.FileInfo(path);
	page.Response.Clear();
	page.Response.Charset = "GB2312";
	page.Response.ContentEncoding = System.Text.Encoding.ASCII;//修改编码ASCII
	//page.Response.ContentEncoding = System.Text.Encoding.UTF8;
	page.Response.AddHeader("Content-Disposition", "attachment; filename=" + page.Server.UrlEncode(file.Name));
	page.Response.AddHeader("Content-Length", file.Length.ToString());
	page.Response.ContentType = "application/ms-excel";
	page.Response.WriteFile(file.FullName);
	page.Response.Flush();
	page.Response.End();
 }

[IEEE_China]

    private static void DownLoadExcel(string path,Page  page)
        {
	System.IO.FileInfo file = new System.IO.FileInfo(path);
	page.Response.Clear();
	page.Response.Charset = "GB2312";
	page.Response.ContentEncoding = System.Text.Encoding.ASCII;
	//page.Response.ContentEncoding = System.Text.Encoding.UTF8;
	page.Response.AddHeader("Content-Disposition", "attachment; filename=" + page.Server.UrlEncode(file.Name));
	page.Response.AddHeader("Content-Length", file.Length.ToString());
	page.Response.ContentType = "application/ms-excel";
	page.Response.WriteFile(file.FullName);
	page.Response.Flush();
	page.Response.End();
 }

[lilinew]

同样问题