i would like to ask and search for help in my code in saving the filtered data into excel...so far i have succes in saving the filtered mysql datas in php into excel but i got some problems in arraging it according to the format i need....can you help me guys please.
I want to make the saved datas in the excel look or formatted just like in the index.php page...can anyone know how to do this??
current code:
<!DOCTYPE html>
<html>
<head>
<title>test</title>
<body>
<?php
require_once 'C:\xampp\htdocs\test\Classes\PHPExcel\IOFactory.php';
$filename = 'file.xlsx';
mysql_connect("localhost","root","") or die ("cant connect!");
mysql_select_db("test") or die ("cant find database!");
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load($filename);
$objWorksheet = $objPHPExcel->getActiveSheet();
$objWorksheet = $objPHPExcel->setActiveSheetIndex(0);
$results = mysql_query("SELECT * FROM score");
echo '<table colspan="2">';
echo '<tr>';
echo '<th>NAME </th>';
echo '<th>SCORE_1 </th>';
echo '<th>SCORE_2 </th>';
echo '<th>OTHER QUALITIES </th>';
echo '<th>INTERVIEW </th>';
echo '<th>TOTAL </th>';
echo '</tr>';
while($row = mysql_fetch_assoc($results)){
echo '<tr align="center">';
echo '<td>'.$name = $row['name'].'</td>';
echo '<td>'.$score1 = $row['score1'].'</td>';
echo '<td>'.$score2 = $row['score2'].'</td>';
echo '<td>'.$other_qual = $row['other_qual'].'</td>';
echo '<td>'.$interview = $row['interview'].'</td>';
echo '<td>'.$total = $row['total'].'</td>';
}
echo '</tr>';
echo '</table>';
$result = mysql_query("SELECT * FROM score");
if(isset($_POST['send'])){
$col = 0;
while( $rows = mysql_fetch_row($result)){
$row = 0;
foreach ($rows as $value){
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $value);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);
$row++;
}
$col++;
}
echo 'saved';
header('Location: Index.php');
}
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save($filename);
?>
<form id="form1" name="form1" method="post" action="" >
<input type="submit" name="send" value="send to excel" id="send" />
</body>
</head>
