PHPExcel Writer创建空白文件

Question

我尝试使用phpexcel writer创建新的excel文件

<?php
     set_include_path(get_include_path() . PATH_SEPARATOR . 'Classes/');
     include 'Classes/PHPExcel/IOFactory.php';
     include 'Classes/PHPExcel/Writer/Excel2007.php';     
     $inputFileName ='mak.xlsx';
    try 
    {
         $inputFileType = PHPExcel_IOFactory::identify($inputFileName);
         $objReader = PHPExcel_IOFactory::createReader($inputFileType);
         $objPHPExcel = $objReader -> load($inputFileName);
         $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
         $objWriter->save('MyExcel.xlsx');            
    }
    catch(Exception $e) 
    {
        die('Error loading file "'.pathinfo($inputFileName,PATHINFO_BASENAME).'": '.$e->getMessage());
    }
?>

i首先加载现有的excel文件，然后将文件数据传递给PHPExcel_Writer_Excel2007($objPHPExcel)。新文件创建为空白文件

Answer 1

试试这个:

$sheet = $objPHPExcel->setActiveSheetIndex(0);
$sheet->setCellValue('A1','TEST');
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);

在你的例子中$objPHPExcel是空的所以这就是为什么你得到空文档