尝试使用 PHP 创建 Excel 文档(致命错误)


Trying to Create an Excel Doc with PHP (Fatal Error)

大家好,我正在尝试创建一个简单的Excel文档,以便我可以开始了解如何在Excel中使用php。但是,当我运行代码时,我遇到了致命错误...... Fatal error: Call to undefined method PHPExcel::getActiviteSheet() in /home3/hutch/public_html/Murphy/ExcelTransfer.php on line 6有人知道如何解决这个问题吗?

<?php
    Include_once 'PHPExcel.php';
    $sheet = new PHPExcel();
    $activeSheet = $sheet->getActiviteSheet();
    $activeSheet->setCellValue('A1','test1');
    $activeSheet->setCellValue('B1','test2');
    $activeSheet->setCellValue('C1','test3');
    $activeSheet->setCellValue('D1','test4');
    header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
    header('Content-Disposition: attachment;filename="report.xlsx"');
    header('Cache-Control: max-age=0');
    $objWriter = PHPExcel_I0Factory::createWriter($sheet, 'Excel2007');
    $obWriter->save('php://output');
    exit;
?>

您有一个拼写错误,使用$sheet->getActiveSheet();而不是$sheet->getActiviteSheet();