Is there a method in PHPExcel to write a PHP array directly into a row?

Question

I understand that I'll need to write a loop inside which I use SetCellValue('cell_name', 'value'); but is there a method in PHPExcel that just accepts a single array and writes that into an Excel sheet row?

Something like:

 $testArray = array('testcelltext1', 'testcelltext2', testcelltext3'); PHPExcel::writeArraytoRow($testArray); //do the other PHPExcel stuff to actually write the file . . . // outputs an excel file in which the PHP array was written to the first row 

I could not find something like that in the included documentation, but that might just be bad PDF search skills...

Answer 1

$objPHPExcel->getActiveSheet()->fromArray($testArray, NULL, 'A1'); 

It's used in a number of the examples

Arguments as described in the API docs

/**  * Fill worksheet from values in array  *  * @param   array   $source                 Source array  * @param   mixed   $nullValue              Value in source array that stands for blank cell  * @param   string  $startCell              Insert array starting from this cell address as the top left coordinate  * @param   boolean $strictNullComparison   Apply strict comparison when testing for null values in the array  * @throws Exception  * @return PHPExcel_Worksheet  */