function getEnergyUsage() { $db = $this->conn; $result = mysqli_query($db, "SELECT * FROM incoming_messages WHERE deleted=0 ORDER BY date_received DESC "); echo "<table width = '880' border='0' class='table_s1' >"; echo "<th width='10'>#</th>"; echo '<th>Respondent</th>'; echo "<th>Fuel</th>"; echo "<th>Amount (Kg)</th>"; echo "<th>Date</th>"; echo "<tbody>"; $num = 0; while ($row = mysqli_fetch_array($result)) { $num++; echo "<tr>"; echo "<td>"; echo $num . '.'; echo "</td>"; echo "<td>"; $model = new ClientModel(); $mobNum = $row['sender_number']; $name = $model->getClientNameByMobNum($mobNum); echo $name; echo "</td>"; echo "<td>"; $id = $row['energy_id']; $message = $this->getFuelName($id); echo $message; echo "</td>"; echo "<td>"; echo $row['amount']; echo "</td>"; echo "<td>"; echo $row['date_received']; echo "</td>"; echo "</tr>"; echo "</tbody>"; } echo "</table>"; }
$objPHPExcel->getActiveSheet()->getStyle($header)->applyFromArray($style); // Miscellaneous glyphs, UTF-8 $num = 1; $x = 2; while ($row = mysqli_fetch_array($result)) { $head = 'A' . $x . ':D' . $x; $objPHPExcel->getActiveSheet()->getStyle($head)->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('00ffcccc'); $style = array('font' => array('bold' => false), 'alignment' => array('horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_GENERAL)); $objPHPExcel->getActiveSheet()->getStyle($head)->applyFromArray($style); $x += 2; $id = $row['energy_id']; $fuelName = $message->getFuelName($id); $amount = $row['amount']; $model = new ClientModel(); $mobNum = $row['sender_number']; $name = $model->getClientNameByMobNum($mobNum); $date = $row['date_received']; $num++; $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $num, $name)->setCellValue('B' . $num, $fuelName)->setCellValue('C' . $num, $amount)->setCellValue('D' . $num, $date); } $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn(0)->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn(1)->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn(2)->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn(3)->setAutoSize(true); //$objPHPExcel->getActiveSheet()->getStyle('A8')->getAlignment()->setWrapText(true); // Rename worksheet //echo date('H:i:s'), " Rename worksheet", EOL; $objPHPExcel->getActiveSheet()->setTitle('Simple'); // Set active sheet index to the first sheet, so Excel opens this as the first sheet $objPHPExcel->setActiveSheetIndex(0); // Save Excel 2007 file