学习地址:
http://www.houdunren.com/houdunren18_lesson_240
插件下载地址:
https://packagist.org/?query=phpoffice
下载插件:
composer require phpoffice/phpspreadsheet
手册地址:
https://phpspreadsheet.readthedocs.io/en/develop/
环境要求:
Software requirements
The following software is required to develop using PhpSpreadsheet:
- PHP version 5.6 or newer
- PHP extension php_zip enabled
- PHP extension php_xml enabled
- PHP extension php_gd2 enabled (if not compiled in)
检测环境:
1 <?php 2 /** 3 ?* Created by Haima. 4 ?* Author:Haima 5 ?* QQ:228654416 6 ?* Date: 2018/7/22 7 ?* Time: 9:35 8 ?*/ 9 10 require ‘vendor/autoload.php‘;11 12 /**13 ?* 环境检测14 ?*/15 16 var_dump(PHP_VERSION);17 var_dump(extension_loaded(‘zip‘));18 var_dump(extension_loaded(‘xml‘));19 var_dump(extension_loaded(‘gd‘));
可以看到环境没有问题
写入数据并保存为Excel文件:
1 <?php 2 /** 3 ?* Created by Haima. 4 ?* Author:Haima 5 ?* QQ:228654416 6 ?* Date: 2018/7/22 7 ?* Time: 9:35 8 ?*/ 9 10 require ‘vendor/autoload.php‘;11 12 ///**13 // * 环境检测14 // */15 //16 //var_dump(PHP_VERSION);17 //var_dump(extension_loaded(‘zip‘));18 //var_dump(extension_loaded(‘xml‘));19 //var_dump(extension_loaded(‘gd‘));20 21 22 use PhpOffice\PhpSpreadsheet\Spreadsheet;23 use PhpOffice\PhpSpreadsheet\Writer\Xlsx;24 25 $spreadsheet = new Spreadsheet();26 $spreadsheet->setActiveSheetIndex(0); //设置要操作的表单页Sheet,传入一个索引27 $sheet = $spreadsheet->getActiveSheet(); //获取当前要操作的表单28 29 //设置表头30 $sheet->setCellValue(‘A1‘, ‘编号‘)31 ????????->setCellValue(‘B1‘,‘用户名‘)32 ????????->setCellValue(‘B1‘,‘昵称‘)33 ????????->setCellValue(‘B1‘,‘年龄‘);34 35 //要写入的数据36 $data = [37 ????[38 ????????‘uid‘ =>1,39 ????????‘username‘ =>‘lisi‘,40 ????????‘nickname‘ =>‘李四‘,41 ????????‘age‘ =>1842 ????],43 ????[44 ????????‘uid‘ =>2,45 ????????‘username‘ =>‘wangwu‘,46 ????????‘nickname‘ =>‘王五‘,47 ????????‘age‘ =>1948 ????],49 ????[50 ????????‘uid‘ =>3,51 ????????‘username‘ =>‘mailiu‘,52 ????????‘nickname‘ =>‘麻六‘,53 ????????‘age‘ =>2054 ????]55 ];56 $sheet->fromArray($data,null,‘A2‘); //从A2行开始写入数据57 $writer = new Xlsx($spreadsheet);58 $writer->save(‘ReadData.xlsx‘); //设置保存文件名称
效果:
php操作Excel
原文地址：https://www.cnblogs.com/haima/p/9349104.html