PHP导出为EXCEL代码 /** * 导出 */ public function createExcelOrder2() { error_reporting(E_ALL); require_once(__DIR__ . '/../../../Public/PHPExcel/Classes/PHPExcel.php'); //引用PHPExcel $obj_phpexcel = new \PHPExcel(); //创建类实例 $obj_phpexcel->setActiveSheetIndex(0); //设置当前页 $status = I('post.status'); $data = M('Order')->where('status=%s', $status)->select(); if ($data) { $A_Z = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'; $p = 1; for ($i = 0; $i < strlen($A_Z); $i++) { if ($p == 1) { $AZ[] = $A_Z[$i]; } else { for ($j = 0; $j < strlen($A_Z); $j++) { $AZ[] = $A_Z[$i] . $A_Z[$j]; } } if ($A_Z[$i] == 'Z' && $p != 0) { $p--; $i = -1; } } $i = 0; foreach ($data[0] as $k => $v) { $cloum = $AZ[$i++]; $obj_phpexcel->getActiveSheet()->setCellValue($cloum . '1', $k); //对第三行1列,填充文字 } $j = 1; foreach ($data as $k => $v) { $i = 0; $j++; foreach ($v as $kk => $vv) { $cloum = $AZ[$i++]; $obj_phpexcel->getActiveSheet()->setCellValue($cloum . '' . $j, $vv); //填充文字 $obj_phpexcel->getActiveSheet()->getColumnDimension($cloum)->setAutoSize(true); //列宽度改为自动宽度 } $i++; } } $obj_phpexcel->setActiveSheetIndex(0); //设置当前活动页 $obj_writer = \PHPExcel_IOFactory::createWriter($obj_phpexcel, 'Excel2007'); //生成文件 $fname = '/Public/Upload/' . date('Y-m-d H:i:s') . '.xlsx'; $obj_writer->save(__DIR__ . '/../../../' . $fname); //保存文件 $data = [ 'url' => $fname ]; die(json_encode($data)); // $obj_writer = PHPExcel_IOFactory::createWriter($obj_phpexcel, 'Excel5'); // $obj_writer->save('shrimpking5.xls'); }
发表评论