1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| include './lib/PHPExcel.php';
// Load template and insert data
$objet = new PHPExcel_Reader_Excel5();
// Open template
$excel = $objet->load('./excel_templates/template_'.$seriesType.'.xls');
$sheet = $excel->getSheet(0);
$i = 0;
foreach ($data as $value){
$sheet->setCellValueByColumnAndRow(0, $i+2, $value['name']);
$sheet->setCellValueByColumnAndRow(1, $i+2, $value['value']);
$sheet->setCellValueByColumnAndRow(2, $i+2, $value['category']);
$i++;
}
$writer = new PHPExcel_Writer_Excel5($excel);
//Ici tu copies dans un fichier
//$writer->save('./excel_templates/'.$seriesType.'Chart.xls');
//ici tu envoie dans le navigateur
header("Content-Type: application/vnd.ms-excel");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("content-disposition: attachment;filename=chartData.xls");
$writer->save('php://output'); |
Partager