2、xls 文件下载
<?php
# 载入composer自动加载文件
require 'vendor/autoload.php';
# 给类文件的命名空间起个别名
use PhpOfficePhpSpreadsheetSpreadsheet;
# 实例化 Spreadsheet 对象
$spreadsheet = new Spreadsheet();
# 获取活动工作薄
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1','ID');
$sheet->setCellValue('B1','姓名');
$sheet->setCellValue('C1','年龄');
$sheet->setCellValue('D1','身高');
$sheet->setCellValueByColumnAndRow(1, 2, 1);
$sheet->setCellValueByColumnAndRow(2, 2, '欧阳克');
$sheet->setCellValueByColumnAndRow(3, 2, '18岁');
$sheet->setCellValueByColumnAndRow(4, 2, '188cm');
$filename = '1.xls';
header('Content-Type:application/vnd.ms-excel');
header('Content-Disposition:attachment;filename=1.xls');
header('Cache-Control:max-age=0');
$writer = PhpOfficePhpSpreadsheetIOFactory::createWriter($spreadsheet, 'Xls');
$writer->save('php://output');
3、设置工作簿标题
setTitle
<?php
# 载入composer自动加载文件
require 'vendor/autoload.php';
# 给类文件的命名空间起个别名
use PhpOfficePhpSpreadsheetSpreadsheet;
# 实例化 Spreadsheet 对象
$spreadsheet = new Spreadsheet();
# 获取活动工作薄
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1','ID');
$sheet->setCellValue('B1','姓名');
$sheet->setCellValue('C1','年龄');
$sheet->setCellValue('D1','身高');
$sheet->setCellValueByColumnAndRow(1, 2, 1);
$sheet->setCellValueByColumnAndRow(2, 2, '欧阳克');
$sheet->setCellValueByColumnAndRow(3, 2, '18岁');
$sheet->setCellValueByColumnAndRow(4, 2, '188cm');
$sheet->setTitle('欧阳克');
// MIME 协议，文件的类型，不设置，会默认html
header('Content-Type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
// MIME 协议的扩展
header('Content-Disposition:attachment;filename=1.xlsx');
// 缓存控制
header('Cache-Control:max-age=0');
$writer = PhpOfficePhpSpreadsheetIOFactory::createWriter($spreadsheet, 'Xlsx');
// php://output 它是一个只写数据流, 允许你以 print 和 echo一样的方式写入到输出缓冲区。
$writer->save('php://output');
4、读取表格
<?php
# 载入composer自动加载文件
require 'vendor/autoload.php';
# 创建读操作
$reader = PhpOfficePhpSpreadsheetIOFactory::createReader('Xlsx');
# 打开文件、载入excel表格
$spreadsheet = $reader->load('1.xlsx');
# 获取活动工作薄
$sheet = $spreadsheet->getActiveSheet();
# 获取 单元格值 和 坐标
$cellC1 = $sheet->getCell('B2');
echo '值: ', $cellC1->getValue(),PHP_EOL;
echo '坐标: ', $cellC1->getCoordinate(),PHP_EOL;
$sheet->setCellValue('B2','欧阳锋');
# 获取 单元格值 和 坐标
$cellC2 = $sheet->getCell('B2');
echo '值: ', $cellC2->getValue(),PHP_EOL;
echo '坐标: ', $cellC2->getCoordinate();
