php tutorial Excel class exports data to xls garbled code from mysql tutorial
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1', iconv('gbk', 'utf-8', 'Chinese Hello'))
->setCellValue('B2', 'world!')
->setCellValue('C1', 'Hello')
->setCellValue('D2', 'world!');
//Use PHP to convert it with its own transcoding function iconv and it will be OK.