Programming Notes

簡易使用php 從遠端server 匯出 excel 至本地

先下載套件 PHPExcel

將 Classes 整包放在server端

建一個 .php 存放在與Classes同位置下

excel.php ↓

<?php

require_once dirname(__FILE__) . '/Classes/PHPExcel.php';

$objPHPExcel = new PHPExcel();

$objPHPExcel->setActiveSheetIndex(0);

$sheet=$objPHPExcel->getActiveSheet();

$sheet->setCellValue('A1','t');
$sheet->setCellValue('B2','e');
$sheet->setCellValue('C3','s');
$sheet->setCellValue('D4','t');

$sheet->setTitle('test');

$objPHPExcel->setActiveSheetIndex(0);

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');

header('Content-Disposition: attachment;filename="test.xls"');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

$objWriter->save("php://output");

exit;

?>

在server端執行後 成功會存檔

預設檔名 test.xls 按存檔下載

檔案下載完畢

完成!