1、获得当前非空的最大的行和列
$lastRow = $objPHPExcel->getActiveSheet()->getHighestRow();
$lastColumn = $objPHPExcel->getActiveSheet()->getHighestColumn();
// 等效于 Array ( [row] => 6 [column] => X )
$lastCell = $objPHPExcel->getActiveSheet()->getHighestRowAndColumn();
2、列的循环
for ($i= 'Q'; $i != $lastColumn; $i+2) {
$c = $i++;
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue($i."3", "确认日期")->setCellValue($c."3", "检定结果");
}
// 上面有时候会报错,
// eg. PHPExcel_Cell::coordinateFromString('AAAA3')
// 我觉得是因为'A'+1 并不是 'B', phpExcel提供了将column字母转换为数字index的函数。
$indexLastColumn = PHPExcel_Cell::columnIndexFromString($lastColumn);
$UIndex = PHPExcel_Cell::columnIndexFromString('T');
for ($i=$UIndex; $i <= $indexLastColumn; $i++) {
$objPHPExcel->setActiveSheetIndex(0)->mergeCellsByColumnAndRow($i, 3, $i, 4);
}
P.S. https://stackoverflow.com/questions/5577856/phpexcel-column-loop
3、自动换行
$objPHPExcel->getActiveSheet()->getStyle('A4:'.$lastColumn.$lastRow)->getAlignment()->setWrapText(true);
//字体变小以适应宽
$objPHPExcel ->getStyle('A1')->getAlignment()->setShrinkToFit(true);
4、行高自适应
$objPHPExcel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(-1);
//列宽的自适应试了各种都不太管用。
5、垂直水平居中
$objPHPExcel->setActiveSheetIndex(0)->getStyle('A1:'.$lastColumn.$lastRow)->getAlignment()
->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER)->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER );
$objPHPExcel->setActiveSheetIndex(0)->getStyle