address a cell with row and col index in getStyle

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

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 ));
$objPHPExcel->getActiveSheet()->getStyle('C9')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDD2);
Instead of 'setCellValue' I can use 'setCellValueByColumnAndRow' but what can I do with the 'getStyle()'-method in the second line?

best,
heinetz