PHPExcel的保存文件问题-php教程-PHP中文网

PHPExcel的保存文件问题

php中文网

发布： 2016-06-20 12:56:42

原创

1542人浏览过

<?phperror_reporting(E_ALL);set_include_path(get_include_path().PATH_SEPARATOR."./php/Classes/");require_once("PHPExcel.php");require_once("PHPExcel/IOFactory.php");$objPHPExcel = new PHPExcel();$objPHPExcel->getProperties()->setCreator("Maarten Balliauw");$objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw");$objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test Document");$objPHPExcel->getProperties()->setSubject("Office 2007 XLSX Test Document");$objPHPExcel->getProperties()->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.");$objPHPExcel->getProperties()->setKeywords("office 2007 openxml php");$objPHPExcel->getProperties()->setCategory("Test result file");$objPHPExcel->setActiveSheetIndex(0);$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Hello1');$objPHPExcel->getActiveSheet()->setCellValue('B1', 'world2');$objPHPExcel->getActiveSheet()->setCellValue('C1', 'Hello3');$objPHPExcel->getActiveSheet()->setCellValue('D1', 'world4');$objPHPExcel->getActiveSheet()->setTitle('sheet01');$objPHPExcel->setActiveSheetIndex(0);$phpexcel = PHPExcel_IOFactory::load("phonelist.xls");$sheet = clone $phpexcel->getActiveSheet();$objPHPExcel->addExternalSheet($sheet);$objPHPExcel->removeSheetByIndex(0);$objPHPExcel->getActiveSheet()->removeRow(3);$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');$objWriter->save(str_replace('.php', '.xlsx', __FILE__));// __FILE__ =>  excel文件的绝对路径?>

登录后复制

这段代码,我用php命令执行,可以创建一个后缀位xlsx的文件.但是如果我把这段代码放在带html标签的文件中然后用火狐浏览器打开.就无法创建,这是什么原因啊.修改过后的文件内容大致如下:

<br> 号码管理系统 <br>

">

姓名 :

error_reporting(e_all);

set_include_path(get_include_path().path_separator."./php/classes");
require_once("phpexcel.php");
require_once("phpexcel/iofactory.php");

$filename = "phonelist.xls";

if (!empty($_post["insert"]))
{
    $objphpexcel = new phpexcel();
    $objphpexcel->getproperties()->setcreator("maarten balliauw");
    $objphpexcel->getproperties()->setlastmodifiedby("maarten balliauw");
    $objphpexcel->getproperties()->settitle("office 2007 xlsx test document");
    $objphpexcel->getproperties()->setsubject("office 2007 xlsx test document");
    $objphpexcel->getproperties()->setdescription("test document for office 2007 xlsx, generated using php classes.");
    $objphpexcel->getproperties()->setkeywords("office 2007 openxml php");
    $objphpexcel->getproperties()->setcategory("test result file");
    $objphpexcel->setactivesheetindex(0);
    $objphpexcel->getactivesheet()->setcellvalue('a1', 'hello1');
    $objphpexcel->getactivesheet()->setcellvalue('b1', 'world2');
    $objphpexcel->getactivesheet()->setcellvalue('c1', 'hello3');
    $objphpexcel->getactivesheet()->setcellvalue('d1', 'world4');
    $objphpexcel->getactivesheet()->settitle('sheet01');
    $objphpexcel->setactivesheetindex(0);

    $objwriter = phpexcel_iofactory::createwriter($objphpexcel, "excel2007");
    $objwriter->save(str_replace('.php', '.xlsx', __file__));
}

?>