我的MYSQL 数据库里面是UTF-8, 取出来时有用mysql_query("set names 'gbk'");
然后通过PHPExcelClasses类导入到EXCEL,但是导入的中文全是乱码, 怎么加事了???set_include_path(get_include_path() . ";" . '../Common/PHPExcelClasses/');
include 'PHPExcel.php';
//或者include 'PHPExcel/Writer/Excel2007.php';
include 'PHPExcel/Writer/Excel5.php'; //用于输出.xls的
//创建一个excel
$objPHPExcel = new PHPExcel();
//保存excel—2007格式
//$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
//$objWriter->setOffice2003Compatibility(true);
$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel); //非2007格式;
// 设置默认sheet
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setCellValue('B1', '学员姓名');
$sql = "select * from Trainer_User ".$Str_Search."";
$res = mysql_query($sql);
if ($rs = mysql_fetch_array($res)) {
$i=1;
do {
$RealName = $rs["RealName"];
$i++;
$objPHPExcel->getActiveSheet()->setCellValue("B".$i, $RealName);
}
while ($rs = mysql_fetch_array($res));
}
然后通过PHPExcelClasses类导入到EXCEL,但是导入的中文全是乱码, 怎么加事了???set_include_path(get_include_path() . ";" . '../Common/PHPExcelClasses/');
include 'PHPExcel.php';
//或者include 'PHPExcel/Writer/Excel2007.php';
include 'PHPExcel/Writer/Excel5.php'; //用于输出.xls的
//创建一个excel
$objPHPExcel = new PHPExcel();
//保存excel—2007格式
//$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
//$objWriter->setOffice2003Compatibility(true);
$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel); //非2007格式;
// 设置默认sheet
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setCellValue('B1', '学员姓名');
$sql = "select * from Trainer_User ".$Str_Search."";
$res = mysql_query($sql);
if ($rs = mysql_fetch_array($res)) {
$i=1;
do {
$RealName = $rs["RealName"];
$i++;
$objPHPExcel->getActiveSheet()->setCellValue("B".$i, $RealName);
}
while ($rs = mysql_fetch_array($res));
}
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码
要与数据库的字符编码集保持一致