Guest User

Untitled

a guest
Dec 14th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. //Set font Size
  2. $objPHPExcel->getActiveSheet()->getStyle("A1:I".$highestRow)->getFont()->setSize(4);
  3.  
  4. //Set Row size
  5. $objPHPExcel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(6);
  6.  
  7. //Loop out data into cells (create excel)
  8. while($value = $stmt->fetch()){
  9.  
  10. //Set start Column
  11. $column = "A";
  12.  
  13. //Set row height
  14. $objPHPExcel->getActiveSheet()->getRowDimension($row)->setRowHeight(6);
  15.  
  16. //Set cell values
  17. $objPHPExcel->getActiveSheet()->SetCellValue($column++.$row, $value['value']);
Add Comment
Please, Sign In to add comment