Adding a new row with PHPExcel?

Question

How can I add a new row to an existing .xls file using PHPExcel?

Do I have to calculate the number of rows that already exist?

If so, how can I do that for an excel file?

Answer 1

Assuming this setup:

$objPHPExcel = PHPExcel_IOFactory::load("foo.xlsx");
$objWorksheet = $objPHPExcel->getActiveSheet();

You can get the number of rows like so:

$num_rows = $objPHPExcel->getActiveSheet()->getHighestRow();

Following this, you can look into inserting a row by using the following statement:

$objWorksheet->insertNewRowBefore($num_rows + 1, 1);

This adds 1 new row before $num_rows.