phpExcel 笔记

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