php excel 导出

最新推荐文章于 2025-04-20 09:25:42 发布

woshihaiyong168

最新推荐文章于 2025-04-20 09:25:42 发布

阅读量337

点赞数

CC 4.0 BY-SA版权

分类专栏：导入导出

本文链接：https://blog.youkuaiyun.com/woshihaiyong168/article/details/52935937

导入导出专栏收录该内容

3 篇文章

订阅专栏

excel表格导出

效果实例:

可以考虑封装一个方法

实现代码：

<?php

//包含路径
require_once './phpexcel/Classes/PHPExcel.php';

$data=array(
    0=>array(
        'id'=>1001,
        'username'=>'张飞',
        'password'=>'123456',
        'address'=>'三国时高老庄250巷101室'
    ),
    1=>array(
        'id'=>1002,
        'username'=>'关羽',
        'password'=>'123456',
        'address'=>'三国时花果山'
    ),
    2=>array(
        'id'=>1003,
        'username'=>'曹操',
        'password'=>'123456',
        'address'=>'延安西路2055弄3号'
    ),
    3=>array(
        'id'=>1004,
        'username'=>'刘备',
        'password'=>'654321',
        'address'=>'愚园路188号3309室'
    )
);

$objPHPExcel=new PHPExcel();
$objPHPExcel->getProperties()->setCreator('http://www.shop.com')
    ->setLastModifiedBy('http://www.shop.com')
    ->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('222222').'_'.date('Y-m-dHis');

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');

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;

}