phpexcle,PHPExcel的使用

项目中遇到了一个到 处&＃xff0c;之前一直用的是JS到处&＃xff0c;到时远远没法满足自己的需求&＃xff0c;所以入手了PHPExcel&＃xff0c;刚开始头大了&＃xff0c;什么跟什么呀&＃xff0c;多亏了度娘和万能的网友&＃xff0c;成功做出了&＃xff0c;这里就简单的复述一下步骤。

首先现在PHPExcel下载&＃xff1a;http://www.php.cn/xiazai/leiku/1491。里面有用的部分CLASS。

然后&＃xff0c;将其打包放在项目的vendor这个目录下。

然后&＃xff0c;在想导出excel的php中填上&＃xff1a;

vendor("PHPExcel.PHPExcel.PHPExcel");

vendor("PHPExcel");

最后常规代码根据自己的需求进行更改即可&＃xff1a;

$data&＃61;array("想要到处的内容");

$objPHPExcel &＃61; new \PHPExcel();

// Set document properties

$objPHPExcel->getProperties()->setCreator("Phpmarker")->setLastModifiedBy("Phpmarker")->settitle("Phpmarker")->setSubject("Phpmarker")->setDescription("Phpmarker")->setKeywords("Phpmarker")->setCategory("Phpmarker");

$objPHPExcel->setActiveSheetIndex(0)->setCellValue(&＃39;A1&＃39;, &＃39;下单时间&＃39;)->setCellValue(&＃39;B1&＃39;, &＃39;订单号&＃39;)->setCellValue(&＃39;C1&＃39;, &＃39;商品&＃39;)->setCellValue(&＃39;D1&＃39;, &＃39;数量&＃39;)->setCellValue(&＃39;E1&＃39;, &＃39;总价&＃39;)->setCellValue(&＃39;F1&＃39;, &＃39;是否支付&＃39;)->setCellValue(&＃39;G1&＃39;, &＃39;盒子信息&＃39;);

// Rename worksheet

$objPHPExcel->getActiveSheet()->settitle(&＃39;Phpmarker-&＃39; . date(&＃39;Y-m-d&＃39;));

// Set active sheet index to the first sheet, so Excel opens this as the first sheet

$objPHPExcel->setActiveSheetIndex(0);

$objPHPExcel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(15);

$objPHPExcel->getActiveSheet()->freezePane(&＃39;A2&＃39;);

$i &＃61;2;//从第几行开始插入

foreach($message as $data){

$objPHPExcel->getActiveSheet()->setCellValue(&＃39;A&＃39; . $i, $data[&＃39;addtime&＃39;])->getstyle(&＃39;A&＃39;.$i)->getAlignment()->setHorizontal(\PHPExcel_style_Alignment::VERTICAL_CENTER);

$objPHPExcel->getActiveSheet()->setCellValue(&＃39;B&＃39; . $i, $data[&＃39;ordernumber&＃39;]);

$objPHPExcel->getActiveSheet()->setCellValue(&＃39;C&＃39; . $i, $data[&＃39;title&＃39;]);

$objPHPExcel->getActiveSheet()->setCellValueExplicit(&＃39;D&＃39;. $i, $data[&＃39;pronum&＃39;],\PHPExcel_Cell_DataType::TYPE_STRING);

$objPHPExcel->getActiveSheet()->getstyle(&＃39;D&＃39; . $i)->getNumberFormat()->setFormatCode("&＃64;");

// 设置文本格式

$objPHPExcel->getActiveSheet()->setCellValueExplicit(&＃39;E&＃39;. $i, $data[&＃39;price&＃39;],\PHPExcel_Cell_DataType::TYPE_STRING);

$objPHPExcel->getActiveSheet()->getstyle(&＃39;E&＃39; . $i)->getAlignment()->setWrapText(true);

$objPHPExcel->getActiveSheet()->setCellValue(&＃39;F&＃39; . $i, $data[&＃39;status&＃39;]);

$objPHPExcel->getActiveSheet()->setCellValue(&＃39;G&＃39; . $i, $data[&＃39;thishezi&＃39;]);

// $objPHPExcel->getActiveSheet()->setCellValue(&＃39;G&＃39; . $i, $data[&＃39;sushe&＃39;]);

// $objPHPExcel->getActiveSheet()->setCellValue(&＃39;H&＃39; . $i, $data[&＃39;name&＃39;]);

// $objPHPExcel->getActiveSheet()->setCellValue(&＃39;I&＃39; . $i, $data[&＃39;tel&＃39;]);

// $objPHPExcel->getActiveSheet()->setCellValue(&＃39;J&＃39; . $i, $data[&＃39;price&＃39;]);

// $objPHPExcel->getActiveSheet()->setCellValue(&＃39;K&＃39; . $i, $data[&＃39;status&＃39;]);

$i&＃43;&＃43; ;

}

$filename &＃61; &＃39;2015030423&＃39;;

ob_end_clean();//清除缓冲区,避免乱码

header(&＃39;Content-Type: application/vnd.ms-excel&＃39;);

header(&＃39;Content-Disposition: attachment;filename&＃61;"&＃39;.$filename.&＃39;.xls"&＃39;);

header(&＃39;Cache-Control: max-age&＃61;0&＃39;);

// If you&＃39;re serving to IE 9, then the following may be needed

header(&＃39;Cache-Control: max-age&＃61;1&＃39;);

// If you&＃39;re serving to IE over SSL, then the following may be needed

header(&＃39;Expires: Mon, 26 Jul 1997 05:00:00 GMT&＃39;); // Date in the past

header(&＃39;Last-Modified: &＃39; . gmdate(&＃39;D, d M Y H:i:s&＃39;) . &＃39; GMT&＃39;); // always modified

header(&＃39;Cache-Control: cache, must-revalidate&＃39;); // HTTP/1.1

header(&＃39;Pragma: public&＃39;); // HTTP/1.0

$objWriter &＃61; new \PHPExcel_Writer_Excel5($objPHPExcel);

$objWriter->save(&＃39;php://output&＃39;);