PHPexcel 导出excel

PHP 数据:
$list = array(
		array('www.51job.com',6211,'招聘|职位搜索'),
 		array('www.51job.com',6211,'招聘|职位搜索'),
 		array('www.51job.com',6211,'招聘|职位搜索'),
		array('www.51job.com',6211,'招聘|职位搜索'),
		array('www.51job.com',6211,'招聘|职位搜索'),
		array('www.51job.com',6211,'招聘|职位搜索'),
		array('www.51job.com',6211,'招聘|职位搜索'),
		array('www.51job.com',6211,'招聘|职位搜索'),
		array('www.51job.com',6211,'招聘|职位搜索'),
		array('www.51job.com',6211,'招聘|职位搜索'),
 		array('www.51job.com',6211,'招聘|职位搜索'),
 		array('www.51job.com',6211,'招聘|职位搜索'),
		array('www.51job.com',6211,'招聘|职位搜索'),
 		array('www.51job.com',6211,'招聘|职位搜索')
       );

require_once '../inc/PHPExcel.php';

$objPHPExcel = new PHPExcel();
	$objPHPExcel->setActiveSheetIndex(0);
	$objPHPExcel->getActiveSheet()->setTitle('主机链接排名');
	
	$objPHPExcel->getActiveSheet()->setCellValue('A1',"{$date}主机链接排名");
	$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true); 
	$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20); 
	$objPHPExcel->getActiveSheet()->mergeCells('A1:D1');
	$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
	
	$rowTitle = array('排名','主机名', 'IP数', '分类');
	
	foreach($rowTitle as $k=>$r){
		$objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($k, 2)->getFont()->setBold(true);//字体加粗
		$objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($k, 2)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//文字居中
		$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($k, 2, $r);
	}
	
	$i=3;
	$j=1;
	foreach($list as $k=>$v){
		$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $i, $k+1);
		$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $i, $v[0]);
		$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $i, $v[1]);
		$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $i, $v[2]);
		$i++;
		$j++;
	}
	
	$filename=date('YmdHi',time()).'主机链接分析.xls'; //save our workbook as this file name
	header('Content-Type: application/vnd.ms-excel'); //mime type
	header('Content-Disposition: attachment;filename="'.$filename.'"'); //tell browser what's the file name
	header('Cache-Control: max-age=0'); //no cache
	
	//save it to Excel5 format (excel 2003 .XLS file), change this to 'Excel2007' (and adjust the filename extension, also the header mime type)
	//if you want to save it as .XLSX Excel 2007 format
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
	//force user to download the Excel file without writing it to server's HD
	$objWriter->save('php://output');



  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值