Some noob questions

Topics: Developer Forum, User Forum
Sep 29, 2011 at 8:05 PM

Hello all,

I was wondering if there is anyway to clean something like this up:

$objPHPExcel->getActiveSheet()->setCellValue('I12', 'Full Cost');
	$objPHPExcel->getActiveSheet()->getStyle('I12')->getFont()->setSize(12);
	$objPHPExcel->getActiveSheet()->getStyle('I12')->getFont()->setBold(true);

Also I'm pulling a bunch of data from MySQL basically a lot of rows with numbers and totals on the last row of each column (number of rows varies by day).  I was wondering how I can pull some of the totals from the bottom of the data and put them up top.  Something like:

$objPHPExcel->getActiveSheet()->setCellValue('=END OF COLUMN I');

Thanks,