我刚刚尝试了你的代码一部分,它完全可以运行。如果你得到的只是乱码,问题可能实际上出在生成表格的部分,请检查那个部分是否有任何错误。以下是我用来测试它的代码:
define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
require_once '../../PHPExcel/Classes/PHPExcel.php';
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("Lumina")
->setLastModifiedBy("Lumina")
->setTitle("Entry members")
->setSubject("Entry members")
->setDescription("List of members participting.")
->setKeywords("office PHPExcel php")
->setCategory("Entry members");
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1', $row_titles['TITLE01'])
->setCellValue('B1', $row_titles['TITLE02'])
->setCellValue('C1', $row_titles['TITLE03'])
->setCellValue('D1', $row_titles['TITLE04'])
->setCellValue('E1', $row_titles['TITLE05'])
->setCellValue('F1', $row_titles['TITLE06'])
->setCellValue('G1', $row_titles['TITLE07'])
->setCellValue('H1', $row_titles['TITLE08'])
->setCellValue('I1', $row_titles['TITLE09'])
->setCellValue('J1', $row_titles['TITLE10'])
->setCellValue('K1', $row_titles['TITLE11'])
->setCellValue('L1', $row_titles['TITLE12'])
->setCellValue('M1', $row_titles['TITLE13'])
->setCellValue('N1', $row_titles['TITLE14'])
->setCellValue('O1', $row_titles['TITLE15'])
->setCellValue('P1', $row_titles['TITLE16'])
->setCellValue('Q1', $row_titles['TITLE17'])
->setCellValue('R1', $row_titles['TITLE18'])
->setCellValue('S1', $row_titles['TITLE19'])
->setCellValue('T1', $row_titles['TITLE20'])
->setCellValue('U1', $row_titles['TEAM_TX'])
->setCellValue('V1', $row_titles['T_SHIRT_SIZE'])
->setCellValue('W1', $row_titles['INPUT1_TX'])
->setCellValue('X1', $row_titles['INPUT2_TX'])
->setCellValue('Y1', $row_titles['INPUT3_TX'])
->setCellValue('Z1', $row_titles['INPUT4_TX']);
$objPHPExcel->getActiveSheet()->setTitle('Participants');
$objPHPExcel->setActiveSheetIndex(0);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save(str_replace('.html', '.xls', __FILE__));
header('Content-type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename="file.xls"');
$objWriter->save('php://output');
我希望这段话能有所帮助,因为我对PHP也是新手。