我使用的版本是openx-2.6.2。在导出excel表格时遇到乱码,现把自己想到解决方法记录一下:
1、文件名:lib/pear/Spreadsheet/Excel/Writer.php文件的function send($filename)函数,第67行加上$filename = iconv(“utf-8″, “gb2312″, $filename);文件名由CA3Q2D77.变成广告分析报告 From Beginning 到 27-03-2009.xls。
2、excel文件内容:lib/pear/Spreadsheet/Excel/Writer/Worksheet.php文件的Writerfunction write($row, $col, $token, $format = 0)函数,第1166行替换为return $this->writeString($row, $col, iconv(“utf-8″, “gb2312″, $token), $format);
3、工作表名称:lib/pear/Spreadsheet/Excel/Writer/Workbook.php文件的function &addWorksheet($name = ”)函数,第318行加上$name = iconv(“utf-8″, “gb2312″, $name);

