PHPExcel导出各种方法总结

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