php 匯出excel檔案

標籤：password   ++   exit   create   max-age   value   sheet   sha   xls   

out_excel.php

<?php
error_reporting(E_ALL);
date_default_timezone_set(‘Asia/Shanghai‘);
require_once ‘PHPExcel/PHPExcel.php‘;
$data=array(
0=>array(
‘id‘=>1001,
‘username‘=>‘張飛‘,
‘password‘=>‘123456‘,
‘address‘=>‘三國時高老莊250巷101室‘
),
1=>array(
‘id‘=>1002,
‘username‘=>‘關羽‘,
‘password‘=>‘123456‘,
‘address‘=>‘三國時花果山‘
)
);
$objPHPExcel=new PHPExcel();
$objPHPExcel->getProperties()->setCreator(‘http://www.jb51.net‘)
->setLastModifiedBy(‘http://www.jb51.net‘)
->setTitle(‘Office 2007 XLSX Document‘)
->setSubject(‘Office 2007 XLSX Document‘)
->setDescription(‘Document for Office 2007 XLSX, generated using PHP classes.‘)
->setKeywords(‘office 2007 openxml php‘)
->setCategory(‘Result file‘);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue(‘A1‘,‘ID‘)
->setCellValue(‘B1‘,‘使用者名稱‘)
->setCellValue(‘C1‘,‘密碼‘)
->setCellValue(‘D1‘,‘地址‘);

$i=2;
foreach($data as $k=>$v){
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue(‘A‘.$i,$v[‘id‘])
->setCellValue(‘B‘.$i,$v[‘username‘])
->setCellValue(‘C‘.$i,$v[‘password‘])
->setCellValue(‘D‘.$i,$v[‘address‘]);
$i++;
}
$objPHPExcel->getActiveSheet()->setTitle(‘三年級2班‘);
$objPHPExcel->setActiveSheetIndex(0);
$filename=urlencode(‘學生資訊統計表‘).‘_‘.date(‘Y-m-dHis‘);

/**產生xlsx檔案*/
header(‘Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet‘);
header(‘Content-Disposition: attachment;filename="‘.$filename.‘.xlsx"‘);
header(‘Cache-Control: max-age=0‘);
$objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,‘Excel2007‘);

/*
*產生xls檔案
header(‘Content-Type: application/vnd.ms-excel‘);
header(‘Content-Disposition: attachment;filename="‘.$filename.‘.xls"‘);
header(‘Cache-Control: max-age=0‘);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, ‘Excel5‘);
*/
$objWriter->save(‘php://output‘);
exit;

php 匯出excel檔案