数据导出成Excel文件,关于字符集的问题

 try
            {
                StreamWriter sw = new StreamWriter(Server.MapPath("Public/DataExport/Data.xls"), false, System.Text.Encoding.GetEncoding(-0));
                string str = "";
                Array array = null;
                for (int i = 0; i < arraylist.Count; i++)
                {
                    str = "";
                    array = ((Array)arraylist[i]);
                    for (int k = 0; k < array.Length; k++)
                    {
                        str += "\t" + (array.GetValue(k) == null ? "" : array.GetValue(k).ToString());
                    }
                    sw.WriteLine(str);
                }
                sw.Close();
                return "xls";
            }
            catch
            {
                return "false";
            }

导出后打开该Excel会发现它并非标准的Excel文件,而是文本文件(制表符)方式分隔的txt文件;当我们再把此文件转换成dataset的时候就出现了问题,它需要我们手动的把文件另存为xls

原文地址:https://www.cnblogs.com/gaoyuchuanIT/p/1410222.html