1

I am creating a excel using phpexcel library on the row I am applying some style like 

$objPHPExcel->getActiveSheet()
    ->getStyle('A'.$row.':Q'.$row)
    ->getFont()
    ->setSize(14); ,
$objPHPExcel->getActiveSheet()
    ->getStyle('A'.$row.':Q'.$row)
    ->getAlignment()
    ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

it is applying some top 3 to 4 pages but rest of pages this formatting is not applied kindly guide any one how i solve this problem this is very important for me.

pnuts
  • 58,317
  • 11
  • 87
  • 139
Raja Bilal Ahmed
  • 81
  • 1
  • 6
  • You're applying that style to a range of cells (a specific row from column A to column Q): I'm unsure how that applies to `pages`. Can you explain in more detail? – Mark Baker Feb 28 '14 at 15:47
  • Perhaps if you want this style for the entire worksheet you could apply it as a default style – Mark Baker Feb 28 '14 at 15:54
  • http://stackoverflow.com/questions/12918586/phpexcel-specific-cell-formatting-from-style-object – Shivam Feb 28 '14 at 16:23

1 Answers1

0

can u please try this?

$objPHPExcel->getDefaultStyle()->getFont()->setName('Times New Roman');
$objPHPExcel->getDefaultStyle()->getFont()->setSize(10);
Hari
  • 303
  • 1
  • 3
  • 11