PHP与EXCEL PHPExcel

1、PHPExcel简介

PHPExcel 是用来操作Office Excel 文档的一个PHP类库，它基于微软的OpenXML标准和PHP语言。可以使用它来读取、写入不同格式的电子表格，如 Excel (BIFF) .xls, Excel 2007 (OfficeOpenXML) .xlsx, CSV, Libre/OpenOffice Calc .ods, Gnumeric, PDF, HTML等等。

2、EXCEL导出文件

include 'PHPExcel.php';include 'PHPExcel/Writer/Excel2007.php';//或者include 'PHPExcel/Writer/Excel5.php'; 用于输出.xls的创建一个excel$objPHPExcel = new PHPExcel();保存excel―2007格式$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);//或者$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel); 非2007格式$objWriter->save("xxx.xlsx");直接输出到浏览器$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);header("Pragma; public");header("Expires; 0″);header("Cache-Control;must-revalidate, post-check=0, pre-check=0″);header("Content-Type;application/force-download");header("Content-Type;application/vnd.ms-execl");header("Content-Type;application/octet-stream");header("Content-Type;application/download");;header('Content-Disposition;attachment;filename="resume.xls"');header("Content-Transfer-Encoding;binary");$objWriter->save('php;//output');――――――――――――――――――――――――――――――――――――――