PHPExcel操作示例

本篇仅介绍简单的excel读写，更多高级特性请查看官方手册

 

PHPExcel类 官方下载地址:http://phpexcel.codeplex.com/releases/
注意需要开启php_zip.dll
如果此类加载不上，比如在框架中，可能要添加 include_path
例如 set_include_path(get_include_path() . PATH_SEPARATOR . '/includes/phpexcel/');

 $PHPExcelObj->createSheet(1); //创建第二张表格

$PHPExcelObj->getActiveSheet()->setTitle(‘title’); //设置活动sheet的名称

写入excel代码:

/* * excel [写入示例] * v1.7.6版本时 支持(xlsx,xls,ods,slk,gnumeric,csv)类型文件 */ include 'PHPExcel.php'; //对文件的原子性操作类 include 'PHPExcel/IOFactory.php'; //顾名思义 以工厂模式封装的读写类 哈~ $PHPExcelObj = new PHPExcel(); /* //文档基本属性设置 $PHPExcelObj->getProperties() ->setCreator("cayman") ->setLastModifiedBy("cayman") ->setTitle("XLS Document") ->setSubject("XLS Document") ->setDescription("---") ->setKeywords("PHP XLS") ->setCategory("TEST"); */ $PHPExcelObj->setActiveSheetIndex(0); //在excel的第一张(Sheet1)表单上写入数据 $PHPExcelObj->getActiveSheet()->setCellValue('A1', '姓名'); //A1是excel的 第1列第1行 $PHPExcelObj->getActiveSheet()->setCellValue('B1', '昵称'); $PHPExcelObj->getActiveSheet()->setCellValue('C1', '网址'); $PHPExcelObj->getActiveSheet()->setCellValue('A2', '小叮'); $PHPExcelObj->getActiveSheet()->setCellValue('B2', 'cayman'); $PHPExcelObj->getActiveSheet()->setCellValue('C2', 'http://blog.csdn.net/diyle'); //将内容写入文件 //第二个参数根据需要选择类型('Excel2007', 'Excel5', 'Excel2003XML', 'OOCalc', 'SYLK', 'Gnumeric', 'CSV') $excelWriter = PHPExcel_IOFactory::createWriter($PHPExcelObj, 'Excel5'); $excelWriter->save('test.xls');

 

读取excel代码:

/* * excel [读取示例] */ include 'PHPExcel/IOFactory.php'; $filename = "d:/test.xls"; $readType = PHPExcel_IOFactory::identify($filename); //在不知道文档类型的情况下获取 $excelReader = PHPExcel_IOFactory::createReader($readType); $PHPExcelObj = $excelReader->load($filename); $currentSheet = $PHPExcelObj->getSheet(0); //选取第一张表单(Sheet1)为当前操作的表单 $excelRows = $currentSheet->getHighestRow(); //获取最大行 $excelColumn = $currentSheet->getHighestColumn(); //获取最大列 foreach(range(1,$excelRows) as $row){ $line = '<p>'; foreach(range('A',$excelColumn) as $column){ $line .= $currentSheet->getCell($column.$row)->getValue().","; } $line .= '</p>'; echo $line; }