S
S
stack242017-04-10 20:56:53
PHP
stack24, 2017-04-10 20:56:53

PHPExcel how to insert empty row?

How to insert a blank line after the last line in a sheet?

$num_rows = $xls->getActiveSheet()->getHighestRow();
 //there need to insert a blank new row 
 $sheet->fromArray($header,null, "A".($num_rows + 1));

Tried to insert just empty data, but they are ignored.
Tell me please. Thanks in advance!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dmitry Bay, 2017-04-10
@kawabanga

it seems, at the excel level, blank lines are ignored.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question