PHPExcel is a library written in pure PHP and providing a set of classes that allow you to write to and read from different spreadsheet file formats, like Excel (BIFF) .xls, Excel 2007 (OfficeOpenXML) .xlsx, CSV, Libre/OpenOffice Calc .ods, Gnumeric, PDF, HTML, ... This project is built around Microsoft's OpenXML standard and PHP.
这是个十分强大的插件,有很多功能,下面是它所支持的. Reading
BIFF 5-8 (.xls) Excel 95 and above
Office Open XML (.xlsx) Excel 2007 and above
SpreadsheetML (.xml) Excel 2003
Open Document Format/OASIS (.ods)
Gnumeric
HTML
SYLK
CSV
Writing
BIFF 8 (.xls) Excel 95 and above
Office Open XML (.xlsx) Excel 2007 and above
HTML
CSV
PDF (using either the tcPDF, DomPDF or mPDF libraries, which need to be installed separately)
相关要求
PHP version 5.2.0 or higher
PHP extension php_zip enabled (required if you need PHPExcel to handle .xlsx .ods or .gnumeric files)
PHP extension php_xml enabled
PHP extension php_gd2 enabled (optional, but required for exact column width autocalculation) 使用PHPexcel导出文件 简单例子
new excel in desk$objSheet = $objPHPExcel->getActiveSheet();//获得当前活动sheet的操作对象$objSheet->getTitle("demo");//set name//$objSheet->setCellValue("A1","姓名")->setCellValue("B1","分数");//fill data//$objSheet->setCellValue("A2","小啦虎")->setCellValue("B2","88");//fill data$array = array( array("","name","score"), array("","Zoe","100"), array("","John","99"));$objSheet->fromArray($array);//直接加载数据块来填充数据$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel,"Excel2007");//按照指定格式生成excel文件$objWriter ->save($dir."/demo_1.xlsx");//save file复制代码