合并后，赋值只能给A1，开始的坐标。
4、拆分单元格
<?php
# 载入composer自动加载文件
require 'vendor/autoload.php';
# 给类文件的命名空间起个别名
use PhpOfficePhpSpreadsheetSpreadsheet;
# 实例化 Spreadsheet 对象
$spreadsheet = new Spreadsheet();
# 获取活动工作薄
$sheet = $spreadsheet->getActiveSheet();
$sheet->mergeCells('A1:B5');
$sheet->unmergeCells('A1:B5');
# Xlsx类 将电子表格保存到文件
use PhpOfficePhpSpreadsheetWriterXlsx;
$writer = new Xlsx($spreadsheet);
$writer->save('1.xlsx');
5、列和行操作
getColumnDimension 获取一列 getWidth 获取一列的宽度 setWidth 设置一列的宽度 setAutoSize 设置一列的宽度自动调整 getDefaultColumnDimension 获取一列的默认值
<?php
# 载入composer自动加载文件
require 'vendor/autoload.php';
# 给类文件的命名空间起个别名
use PhpOfficePhpSpreadsheetSpreadsheet;
# 实例化 Spreadsheet 对象
$spreadsheet = new Spreadsheet();
# 获取活动工作薄
$sheet = $spreadsheet->getActiveSheet();
echo $sheet->getColumnDimension('A')->getWidth();
$sheet->getColumnDimension('A')->setWidth(100);
$sheet->getColumnDimension('B')->setAutoSize(true);
$sheet->getDefaultColumnDimension()->setWidth(1);
# Xlsx类 将电子表格保存到文件
use PhpOfficePhpSpreadsheetWriterXlsx;
$writer = new Xlsx($spreadsheet);
$writer->save('1.xlsx');
getRowDimension 获取一行
getRowHeight 获取一行的高度
setRowHeight 设置一行的高度
<?php
# 载入composer自动加载文件
require 'vendor/autoload.php';
# 给类文件的命名空间起个别名
use PhpOfficePhpSpreadsheetSpreadsheet;
# 实例化 Spreadsheet 对象
$spreadsheet = new Spreadsheet();
# 获取活动工作薄
$sheet = $spreadsheet->getActiveSheet();
echo $sheet->getRowDimension(1)->getRowHeight();
$sheet->getRowDimension(1)->setRowHeight(100);
$sheet->getDefaultRowDimension()->setRowHeight(1);
# Xlsx类 将电子表格保存到文件
use PhpOfficePhpSpreadsheetWriterXlsx;
$writer = new Xlsx($spreadsheet);
$writer->save('1.xlsx');
getHighestColumn 获取总列数
getHighestRow 获取总行数
<?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->setCellValueByColumnAndRow(1, 3, 2);
$sheet->setCellValueByColumnAndRow(2, 3, '黄蓉');
$sheet->setCellValueByColumnAndRow(3, 3, '17岁');
$sheet->setCellValueByColumnAndRow(4, 3, '165cm');
echo $sheet->getHighestColumn();
echo $sheet->getHighestRow();
# Xlsx类 将电子表格保存到文件
use PhpOfficePhpSpreadsheetWriterXlsx;
$writer = new Xlsx($spreadsheet);
$writer->save('1.xlsx');
