get first empty cell

Topics: Developer Forum
Apr 22, 2014 at 4:36 PM
Edited Apr 22, 2014 at 4:38 PM
hi all
is there any way to get first empty cell per row or column.
   A   B   C
1  *   *
2  *
$objPHPExcel->getActiveSheet()->getFirstEmptyCell('B'); // return 2 or B2
$objPHPExcel->getActiveSheet()->getFirstEmptyCell(2); // retrun B or B2
May 11, 2014 at 6:13 PM
nobody is here?
May 11, 2014 at 6:32 PM
Besides writing your own code to loop and testing each cell, there is no built-in method

The 1.8.0 release added methods to get the last cell in any row, or in any column; but there may be empty cells earlier in the row or in the column
Marked as answer by ooghry on 5/11/2014 at 10:38 AM