在PHPEXCEL中使用activecell转到下面的n行

Question

I would like to put a value in the cell B24

I'm using this code :

$active_cell = $objPHPExcel->getActiveSheet()->setSelectedCell('B'.(17+$arr_periodes[2]));

Then, I would like to go 4 lines below

How can I use $active_cell to go 4 rows below ?

I tried OFFSET, it doesn't work :

$objPHPExcel->getActiveSheet()->setSelectedCell($active_cell:OFFSET($arr_periodes[1]),'x');

Answer 1

This is what I did, it's working :

$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(($arr_periodes[2]+1),17+($arr_periodes[1]),'X');