address a cell with row and col index in getStyle

Topics: User Forum
May 17, 2013 at 10:53 PM
Edited May 17, 2013 at 10:55 PM

i'me new to PHPExcel and I try to generate a Spreadsheet from a PHP-array. I found the method 'setCellValueByColumnAndRow()' and could do nearly everything I want, but now I trie to format a cell as date and found this way in your example '02-types-xls.php':
$objPHPExcel->getActiveSheet()->setCellValue('A9', 'Date/Time')
                              ->setCellValue('B9', 'Date')
                              ->setCellValue('C9', PHPExcel_Shared_Date::PHPToExcel( $dateTimeNow ));
Instead of 'setCellValue' I can use 'setCellValueByColumnAndRow' but what can I do with the 'getStyle()'-method in the second line?