PhpExcel - How insert the same row after row N?

2020-07-03 06:32发布

I have php template. this is a empty table (T0 rows) with some footer at the bottom. From php i try to fill the table, but if i had T1 rows (T1 > T0) then trouble appers.

I beleve that empty table should contains one empty row. And we know this row number. Then we copy this row (insert the same rows) T1 times and fill empty table. Footer goes down. And everything will be ok

Give me an example, how i can do this. Thank you.

PhpExcel 1.7.6

标签: php phpexcel
1条回答
倾城 Initia
2楼-- · 2020-07-03 06:58

Just copying what @markBaker said (so that we can set the solution as an answer):

//Insert 10 new rows between rows 1 and 2 
$objPHPExcel->getActiveSheet()->insertNewRowBefore(2,10); 

Now applying the style of the row 2 to the inserted rows:

$objPHPExcel->getActiveSheet()->duplicateStyle($objPHPExcel->getActiveSheet()->getStyle('A1'),'A2:A10'); 
查看更多
登录 后发表回答