Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //Set font Size
- $objPHPExcel->getActiveSheet()->getStyle("A1:I".$highestRow)->getFont()->setSize(4);
- //Set Row size
- $objPHPExcel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(6);
- //Loop out data into cells (create excel)
- while($value = $stmt->fetch()){
- //Set start Column
- $column = "A";
- //Set row height
- $objPHPExcel->getActiveSheet()->getRowDimension($row)->setRowHeight(6);
- //Set cell values
- $objPHPExcel->getActiveSheet()->SetCellValue($column++.$row, $value['value']);
Add Comment
Please, Sign In to add comment