PHPExcel导出
方法一、
https://blog.csdn.net/u014236259/article/details/60601767
public function ExportExcelOrder($data, $name)
{
vendor('PHPExcel.PHPExcel'); //引入PHPExcel类
$objPHPExcel = new \PHPExcel(); //实例化 相当于在桌面新建一个excel
// 表头
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1', 'id')
->setCellValue('B1', '订单编号')
->setCellValue('C1', '收货人姓名')
->setCellValue('D1', '收货人电话')
->setCellValue('E1', '地址')
->setCellValue('F1', '省份')
->setCellValue('G1', '返现金额')
->setCellValue('H1', '品牌名称');
//设置内容水平居中
$objPHPExcel->setActiveSheetIndex(0)->getStyle('A')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
// 设置个表格宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(24);
//设置单元格自动宽度
$objPHPExcel->getActiveSheet()->getColumnDimension("A")->setAutoSize(true);
// 内容
for ($i = 0, $len = count($data); $i < $len; $i++) {
$objPHPExcel->getActiveSheet(0)->setCellValue('A' . ($i + 2), $data[$i]['part_order_id']);
$objPHPExcel->getActiveSheet(0)->setCellValue('B' . ($i + 2), $data[$i]['order_id']);
$objPHPExcel->getActiveSheet(0)->setCellValue('C' . ($i + 2), $data[$i]['accept_name']);
$objPHPExcel->getActiveSheet(0)->setCellValue('D' . ($i + 2), $data[$i]['phone