PHP使用PhpSpreadsheet操作Excel实例详解

3、单元格文字颜色

getColor() 获取坐标颜色 setRGB() 设置字体颜色 getRGB() 获取字体颜色 setARGB() 设置字体颜色 getARGB() 获取字体颜色

<?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');

	$sheet->getStyle('B2')->getFont()->getColor()->setRGB('#AEEEEE');
	echo $sheet->getStyle('B2')->getFont()->getColor()->getRGB(),PHP_EOL;

	$sheet->getStyle('B3')->getFont()->getColor()->setARGB('FFFF0000');
	echo $sheet->getStyle('B3')->getFont()->getColor()->getARGB();

	# Xlsx类 将电子表格保存到文件
	use PhpOfficePhpSpreadsheetWriterXlsx;
	$writer = new Xlsx($spreadsheet);
	$writer->save('1.xlsx');

4、单元格格式

getNumberFormat 获取格式 setFormatCode 设置格式

<?php
	# 载入composer自动加载文件
	require 'vendor/autoload.php';
	# 给类文件的命名空间起个别名
	use PhpOfficePhpSpreadsheetSpreadsheet;
	# 实例化 Spreadsheet 对象
	$spreadsheet = new Spreadsheet();
	# 获取活动工作薄
	$sheet = $spreadsheet->getActiveSheet();

	$sheet->setCellValue('A1','2019-10-10 10:10:10');
	$sheet->setCellValue('A2','2019-10-10 10:10:10');
	$sheet->getStyle('A2')->getNumberFormat()->setFormatCode(PhpOfficePhpSpreadsheetStyleNumberFormat::FORMAT_DATE_YYYYMMDD2);

	# Xlsx类 将电子表格保存到文件
	use PhpOfficePhpSpreadsheetWriterXlsx;
	$writer = new Xlsx($spreadsheet);
	$writer->save('1.xlsx');

setWrapText 设置文本里的n符合为：换行

<?php
	# 载入composer自动加载文件
	require 'vendor/autoload.php';
	# 给类文件的命名空间起个别名
	use PhpOfficePhpSpreadsheetSpreadsheet;
	# 实例化 Spreadsheet 对象
	$spreadsheet = new Spreadsheet();
	# 获取活动工作薄
	$sheet = $spreadsheet->getActiveSheet();

	$sheet->setCellValue('A1',"欧阳克n黄蓉");
	$sheet->getStyle('A1')->getAlignment()->setWrapText(true);

	# Xlsx类 将电子表格保存到文件
	use PhpOfficePhpSpreadsheetWriterXlsx;
	$writer = new Xlsx($spreadsheet);
	$writer->save('1.xlsx');
								 
 3/11   首页 上一页 1 2 3 4 5 6 下一页 尾页