用PHPExcel添加新行? [英] Adding a new row with PHPExcel?

问题描述

如何使用PHPExcel将新行添加到现有的.xls文件中?

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?

如果是这样，我该如何为一个excel文件呢?

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

推荐答案

假定此设置:

$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);

这将在$num_rows之前添加1行.

这篇关于用PHPExcel添加新行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！