phpexcel 合并单元格后的动态行高

思路参考:https://www.it1352.com/1745868.html,如下所示:

You can also do it like this

  1. Merge cells you want, for example: A7:C7
  2. Copy context of it to one cell for instance Z7
  3. Set the width of the merged cells to Z7
  4. Apply Wrap Text to the Z7
  5. Make Z7 not visible

脚本实现:

        

$objActSheet->getColumnDimension(‘A‘)->setWidth(26);
        for($i=1;$i<14;$i++){
            $objActSheet->getColumnDimension($col_name[$i])->setWidth(17);
        }
        $objActSheet->getColumnDimension(‘Z‘)->setWidth(43);
        $objActSheet->getStyle(‘A:Z‘)->getAlignment()->setWrapText(true); //Adaptive line feed
......
$objActSheet->setCellValue(‘Z‘.$current_row,$val);
$objActSheet->getColumnDimension(‘Z‘)->setVisible(false);
......

 

phpexcel 合并单元格后的动态行高

上一篇:OpenCV 几何图像变换-cv::getAffineTransform(仿射变换)


下一篇:css 旋转div