Phpexcel Cant Set Cell Values To In Yii When String Are Special Chararcters.

Yii 1.1 General Discussion
1

Hello everyone. How can I fix special characters cannot be set to PHPExcel cells (returns empty string)? I tried to run the code below with or without yii framework. But the problem only exist when using yii.




$objPHPExcel = new PHPExcel();


$objPHPExcel->setActiveSheetIndex(0)

    ->setCellValue('A1', 'Hello')

    ->setCellValue('B2', 'world!')

    ->setCellValue('C1', 'Hello')

    ->setCellValue('D2', 'world!');

$objPHPExcel->setActiveSheetIndex(0)

    ->setCellValue('A4', 'Miscellaneous glyphs')

    ->setCellValue('A5', 'éàèùâêîôûëïüÿäöüç');


$objPHPExcel->getActiveSheet()->setTitle('Simple');


$objPHPExcel->setActiveSheetIndex(0);


echo $objPHPExcel->getActiveSheet()->getCell('A1')->getValue();


//problem

echo $objPHPExcel->getActiveSheet()->getCell('A5')->getValue();//what's wrong; didn't echo out "éàèùâêîôûëïüÿäöüç"


echo $objPHPExcel->getActiveSheet()->getCell('A4')->getValue();

die;