<?php
class IndexAction extends Action {
public function imorder()
{
$M=M('模型');
$list = $M->select();
$num=count($list);
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
/*
*这里也可以导入文件
*
*/
require_once './ThinkPHP/Extend/Library/ORG/Net/PHPExcel.class.php';
require_once './ThinkPHP/Extend/Library/ORG/Net/PHPExcel/IOFactory.php';
require_once './ThinkPHP/Extend/Library/ORG/Net/PHPExcel/Reader/Excel5.php';
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
->setLastModifiedBy("Maarten Balliauw")
->setTitle("Office 2007 XLSX Test Document")
->setSubject("Office 2007 XLSX Test Document")
->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
->setKeywords("office 2007 openxml php")
->setCategory("Test result file");
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1', '会员ID')
->setCellValue('B1', '会员ID')
->setCellValue('C1', '会员ID')
->setCellValue('D1', '会员ID')
->setCellValue('E1', '会员ID')
->setCellValue('F1', '会员ID')
->setCellValue('G1', '会员ID')
->setCellValue('H1', '会员ID')
->setCellValue('I1', '会员ID')
->setCellValue('J1', '会员ID')
->setCellValue('K1', '会员ID')
->setCellValue('L1', '会员ID')
->setCellValue('M1', '会员ID');
for ($i=0; $i < $num; $i++) {
$n=$i+2;
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A'.$n, $list[$i]['id'])
->setCellValue('B'.$n, $list[$i]['id'])
->setCellValue('C'.$n, $list[$i]['id'])
->setCellValue('D'.$n, '')
->setCellValue('E'.$n, $list[$i]['id'])
->setCellValue('F'.$n, $list[$i]['id'])
->setCellValue('G'.$n, $list[$i]['id'])
->setCellValue('H'.$n, $list[$i]['id'])
->setCellValue('I'.$n, $list[$i]['id'])
->setCellValue('J'.$n, $list[$i]['id'])
->setCellValue('K'.$n, $list[$i]['id'])
->setCellValue('L'.$n, '')
->setCellValue('M'.$n, '');
}
$objPHPExcel->getActiveSheet()->setTitle('title');
$objPHPExcel->setActiveSheetIndex(0);
spl_autoload_register(array('Think','autoload'));
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="文件名.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;
}
}
Thinkphp使用PHPExcel导出Excel表格
最新推荐文章于 2024-04-30 14:29:56 发布