PHPExcel使用笔记

JoLonn

于 2022-08-25 20:45:21 发布

阅读量193

点赞数

分类专栏： PHP 文章标签： phpexcel

本文链接：https://blog.csdn.net/qq_16149125/article/details/126489230

版权

PHP 专栏收录该内容

37 篇文章 0 订阅

订阅专栏

1、多行文本展示

// 支持换行
$objPHPExcelActive->getRowDimension($i)->getZeroHeight(19);
$objPHPExcelActive->getStyle('H'.$i)->getAlignment()->setWrapText(true);// 自动分行，高度自适应


$objPHPExcelActive->getStyle('A1')->getFont()->setSize(22);
$objPHPExcelActive->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcelActive->getStyle('A1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcelActive->getRowDimension(1)->setRowHeight(35);

// 合计
$objPHPExcelActive->setCellValue('C'.($i+1),'合计');
$objPHPExcelActive->getStyle('C'.($i+1))->getFont()->setBold(true);
$objPHPExcelActive->getRowDimension($i+1)->setRowHeight(38);
// 汇款信息
$objPHPExcelActive->setCellValue('A'.($i+2),"汇款信息");
$objPHPExcelActive->mergeCells('B'.($i+2).':'.'I'.($i+2));
$objPHPExcelActive->setCellValue('B'.($i+2),'运费随货款一起转到指定的银行账号中');
$objPHPExcelActive->getStyle('A'.($i+2))->getFont()->setBold(true);
$objPHPExcelActive->getStyle('B'.($i+2))->getFont()->setBold(true);
$objPHPExcelActive->getRowDimension($i+2)->setRowHeight(40);
// 盖章
$objPHPExcelActive->mergeCells('A'.($i+3).':'.'E'.($i+3));
$objPHPExcelActive->setCellValue('A'.($i+3),'甲方盖章：'.$statement['purchase_name_cn']."\n");
$objPHPExcelActive->mergeCells('F'.($i+3).':'.'I'.($i+3));
$objPHPExcelActive->setCellValue('F'.($i+3),'乙方盖章：'.$statement['supplier_name']."\n");
$objPHPExcelActive->getRowDimension($i+3)->setRowHeight(150);
$objPHPExcelActive->getStyle('A'.($i+3))->getAlignment()->setWrapText(true);
$objPHPExcelActive->getStyle('E'.($i+3))->getAlignment()->setWrapText(true);


// 设置边框线
$styleThinBlackBorderOutline = array(
'borders' => array(
	'allborders' => array( //设置全部边框
		'style' => \PHPExcel_Style_Border::BORDER_THIN,//粗的是thick
	)
)
);
$objPHPExcel->getActiveSheet()->getStyle('A1:'.'I'.($i + 3))->applyFromArray($styleThinBlackBorderOutline);

// 设置第一个sheet为工作的sheet
$objPHPExcelActive->setTitle('运费明细');