6、单元格样式
applyFromArray
<?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');
$styleArray = [
// use PhpOfficePhpSpreadsheetStyleAlignment; 文件里常量，就是参数
// Alignment::HORIZONTAL_CENTER 水平居中
// Alignment::VERTICAL_CENTER 垂直居中
'alignment' => [
// 'horizontal' => Alignment::HORIZONTAL_CENTER, //水平居中
// 'vertical' => Alignment::VERTICAL_CENTER, //垂直居中
'horizontal' => 'center', //水平居中
'vertical' => 'center', //垂直居中
],
// use PhpOfficePhpSpreadsheetStyleBorder; 文件里常量，就是参数
// Border::BORDER_THICK 边框样式
'borders' => [
'outline' => [
// 'borderStyle' => 'PhpOfficePhpSpreadsheetStyleBorder::BORDER_THICK',
'borderStyle' => 'thick',
'color' => ['argb' => 'FFFF0000'],
],
],
'font' => [
'name' => '黑体',
'bold' => true,
'size' => 22
]
];
$sheet->getStyle('A1')->applyFromArray($styleArray);
# Xlsx类 将电子表格保存到文件
use PhpOfficePhpSpreadsheetWriterXlsx;
$writer = new Xlsx($spreadsheet);
$writer->save('1.xlsx');
五、工作薄操作
1、xlsx 文件下载
IOFactory::createWriter 写入到文件
<?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');
// 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');
