使用PHPExcel导出excel文件

require_once './lib/phpexcel/PHPExcel.php';
require_once './lib/phpexcel/PHPExcel/Writer/Excel2007.php';
require_once './lib/phpexcel/PHPExcel/Writer/Excel5.php';
include_once './lib/phpexcel/PHPExcel/IOFactory.php';
$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_in_memory_gzip;
$cacheSettings = array();
PHPExcel_Settings::setCacheStorageMethod($cacheMethod,$cacheSettings);

$objExcel = new PHPExcel();
$objExcel->getProperties()->setCreator("ItUtil.et");
$objExcel->getProperties()->setLastModifiedBy("ItUtil.net");
$objExcel->getProperties()->setTitle("导出测试");
$objExcel->getProperties()->setSubject("导出测试");
$objExcel->setActiveSheetIndex(0);

$objExcel->getActiveSheet()->setCellValue('A1', "编号");
$objExcel->getActiveSheet()->setCellValue('B1', "员工姓名");
$objExcel->getActiveSheet()->setCellValue('C1', "所属部门");
$objExcel->getActiveSheet()->setCellValue('D1', "入职时间");
$objExcel->getActiveSheet()->setCellValue('E1', "年龄");

$objExcel->getActiveSheet()->getStyle('A1:E1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objExcel->getActiveSheet()->getStyle('A1:E1')->getFill()->getStartColor()->setARGB('ffcccccc');

$i=1;
$items = array();
$item[] = array("no"=>"20200000001", "exploeeName"=>"张三", "department"=>"研发部", "time"=>"2020", "age"=>28);
$totalCount = count($items);

for($j = 0; $j<$totalCount; $j++)
{
	$i++;
	$item = $items[$j];
	$objExcel->getActiveSheet()->setCellValueExplicitByColumnAndRow("A","$i",$item['no']);
	$objExcel->getActiveSheet()->setCellValueExplicit("B$i", $item['exploeeName']);
	$objExcel->getActiveSheet()->setCellValueExplicit("C$i", $item['department']);
	$objExcel->getActiveSheet()->setCellValueExplicit("D$i", $item['time']);
	$objExcel->getActiveSheet()->setCellValueExplicit("E$i", $item['age']);
}

// 高置列的宽度
$objExcel->getActiveSheet()->getColumnDimension('A')->setWidth(16);
$objExcel->getActiveSheet()->getColumnDimension('B')->setWidth(50);
$objExcel->getActiveSheet()->getColumnDimension('C')->setWidth(50);
$objExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$objExcel->getActiveSheet()->getColumnDimension('E')->setWidth(24);

// 设置页方向和规模
$objExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_PORTRAIT);
$objExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
$objExcel->setActiveSheetIndex(0);

$file = "导出记录.xls";
$filePath = "./down/";
if(!file_exists($filePath))
{
	mkdir($filePath,0755,true);
	chmod($filePath,0755);
}
$filePath .= "/{$file}";

$objWriter = PHPExcel_IOFactory::createWriter($objExcel, 'Excel5');
$objWriter->save($filePath);