phpexcel导出excel表简单入门示例
先下载PHPEXCEL类文件，放在class目录下面，然后新建一个index.php文件，内容如下<?php
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
if (PHP_SAPI == 'cli')
die('This example should only be run from a Web Browser');
/** Include PHPExcel */
require_once 'class/PHPExcel.php';
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set document properties
$objPHPExcel->getProperties()->setCreator("duchengjiu")
->setLastModifiedBy("duchengjiu")
->setTitle("Office 2007 XLSX userTable")
->setSubject("Office 2007 XLSX userTable")
->setDescription("Test userTable for Office 2007 XLSX.")
->setKeywords("office 2007")
->setCategory("userTable");
//连接数据库，获取数据库中的信息
mysql_connect('localhost','root','root');
mysql_select_db('test');
$result = mysql_query("select * from user");
$i = 1;
while(list($id, $username, $password) = mysql_fetch_row($result)){
// Add some data
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A'.$i, $id)
->setCellValue('B'.$i, $username)
->setCellValue('C'.$i, $password);
$i++;
}
$objPHPExcel->getActiveSheet(0)->setTitle('Simple');
$objPHPExcel->setActiveSheetIndex(0);
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="01simple.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;
?>
页:
[1]