PHPExcel
是用来操作Office Excel 文档的一个PHP类库，可以使用它来读取、写入不同格式的电子表格
Github：https://github.com/PHPOffice/PHPExcel
php
<?php//引入类require_once ‘PHPExcel-1.8/Classes/PHPExcel.php‘;$objPHPExcel = new PHPExcel();//创建对象//设置文件属性$objPHPExcel->getProperties()->setCreator("pine") ????????????????????????????->setLastModifiedBy("pine") ????????????????????????????->setTitle("Product Title") ????????????????????????????->setSubject("Product Subject") ????????????????????????????->setDescription("Product Description") ????????????????????????????->setKeywords("Product") ????????????????????????????->setCategory("Product");//设置内容$objPHPExcel->setActiveSheetIndex(0) ???????????->setCellValue(‘A1‘, ‘产品名称‘) ???????????->setCellValue(‘B1‘, ‘品牌‘) ???????????->setCellValue(‘C1‘, ‘成本价‘) ???????????->setCellValue(‘D1‘, ‘销售价‘) ???????????->setCellValue(‘A2‘, ‘I8‘) ???????????->setCellValue(‘B2‘, ‘苹果‘) ???????????->setCellValue(‘C2‘, ‘1000‘) ???????????->setCellValue(‘D2‘, ‘10000‘) ???????????->setCellValue(‘A3‘, ‘MATE2000‘) ???????????->setCellValue(‘B3‘, ‘华为‘) ???????????->setCellValue(‘C3‘, ‘1500‘) ???????????->setCellValue(‘D3‘, ‘6000‘);$objPHPExcel->getActiveSheet()->setTitle(‘2018产品销售‘);//设置工作表名称$objPHPExcel->createSheet();//创建一个新的工作表//设置内容$objPHPExcel->setActiveSheetIndex(1) ???????????->setCellValue(‘A1‘, ‘筹备中‘);$objPHPExcel->getActiveSheet()->setTitle(‘2019计划销售‘);//设置工作表名称//创建$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, ‘Excel2007‘);$objWriter->save(str_replace(‘.php‘, ‘.xlsx‘, __FILE__));导出后结果
PHPExcel导出
原文地址：https://www.cnblogs.com/mg007/p/10348072.html