phpExcel的基础案例
<?php require_once ('PHPExcel.php'); //require_once 'PHPExcel/Writer/Excel2007.php'; // 用于 excel-2007 格式 $objExcel = new PHPExcel(); $objWriter = new PHPExcel_Writer_Excel5($objExcel); //$objWriter = new PHPExcel_Writer_Excel2007($objExcel); // 用于 2007 格式 //************************************* //设置文档基本属性 $objProps = $objExcel->getProperties(); $objProps->setCreator("Zeal Li"); $objProps->setLastModifiedBy("Zeal Li"); $objProps->setTitle("Office XLS Test Document"); $objProps->setSubject("Office XLS Test Document, Demo"); $objProps->setDescription("Test document, generated by PHPExcel."); $objProps->setKeywords("office excel PHPExcel"); $objProps->setCategory("Test"); //缺省情况下,PHPExcel会自动创建第一个sheet被设置SheetIndex=0 $objExcel->setActiveSheetIndex(0); $objActSheet = $objExcel->getActiveSheet(); //设置当前活动sheet的名称 $objActSheet->setTitle('测试Sheet'); $objActSheet->setCellValue('A1', '字符串内容'); $objActSheet->setCellValue('A2', 26); $objActSheet->setCellValue('A3', 90); $objActSheet->setCellValue('A4', '=SUM(A2:A3)'); $a=$objActSheet->getColumnDimension('A'); $a->setWidth(20); $outputFileName = "output.xls"; //到文件 ////$objWriter->save($outputFileName); //or //到浏览器 header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); header("Content-Type: application/download"); header('Content-Disposition:inline;filename="'.$outputFileName.'"'); header("Content-Transfer-Encoding: binary"); header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Pragma: no-cache"); $objWriter->save('php://output'); ?>
在调用的时候可能会出现 class ZipArchive not found 的错误;
解决方法:
在Windows下的解决办法是:
1、在php.ini文件中,将extension=php_zip.dll前面的分号“;”去除;
(如果没有,请添加extension=php_zip.dll此行并确保php_zip.dll文件存在相应的目录)
然后同样在php.ini文件中,将 zlib.output_compression = Off 改为 zlib.output_compression = On ;
2、重启Apache服务器。