使用PHPExcel进行服务端导出可以看下老大贴子 #使用PHPExcel进行服务端导出
老大帖子时间导出来是时间戳，并没转换，而且导出的样式有点....:joy: :joy: :joy:
只修改控制器代码

 public function export()    {        if ($this->request->isPost()) {            set_time_limit(0);            $search = $this->request->post('search');            $ids = $this->request->post('ids');            $filter = $this->request->post('filter');            $op = $this->request->post('op');            $columns = $this->request->post('columns');            $excel = new PHPExcel();            $excel->getProperties()                ->setCreator("FastAdmin")                ->setLastModifiedBy("FastAdmin")                ->setTitle("标题")                ->setSubject("Subject");            $excel->getDefaultStyle()->getFont()->setName('Microsoft Yahei');            $excel->getDefaultStyle()->getFont()->setSize(12);            $this->sharedStyle = new PHPExcel_Style();            $this->sharedStyle->applyFromArray(                array(                    'fill'      => array(                        'type'  => PHPExcel_Style_Fill::FILL_SOLID,                        'color' => array('rgb' => '000000')                    ),                    'font'      => array(                        'color' => array('rgb' => "000000"),                    ),                    'alignment' => array(                        'vertical'   => PHPExcel_Style_Alignment::VERTICAL_CENTER,                        'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,                        'indent'     => 1                    ),                    'borders'   => array(                        'allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN),                    )                ));            $worksheet = $excel->setActiveSheetIndex(0);            $worksheet->setTitle('标题');            $whereIds = $ids == 'all' ? '1=1' : ['id' => ['in', explode(',', $ids)]];            $this->request->get(['search' => $search, 'ids' => $ids, 'filter' => $filter, 'op' => $op]);            list($where, $sort, $order, $offset, $limit) = $this->buildparams();            $line = 1;            $list = [];            $this->model                ->field($columns)                ->where($where)                ->where($whereIds)                ->chunk(100, function ($items) use (&$list, &$line, &$worksheet) {                    $styleArray = array(                        'font' => array(                            'bold'  => false,//加粗                            'color' => array('rgb' => '000000'),//字体颜色                            'size'  => 10,//字体大小                            'name'  => 'Verdana'                        ));                    $list = $items = collection($items)->toArray();                    foreach ($items as $index => $item) {                        $line++;                        $col = 0;                        foreach ($item as $field => $value) {                          //时间戳转换，createtime时间的字段                           if(strpos($field,'createtime')!==false){                $value=date('Y-m-d H:i:s',$value);                };                          //处理身份证，certcode身份证字段                            if(strpos($field,'certcode')!==false){                                $value=' '.$value;                             };                            $worksheet->setCellValueByColumnAndRow($col, $line, $value);                            $worksheet->getStyleByColumnAndRow($col, $line)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);                            $worksheet->getCellByColumnAndRow($col, $line)->getStyle()->applyFromArray($styleArray);                            $col++;                        }                    }                });            $first = array_keys($list[0]);            foreach ($first as $index => $item) {                $worksheet->setCellValueByColumnAndRow($index, 1, __($item));            }            $excel->createSheet();            // Redirect output to a client’s web browser (Excel2007)            $title = date("YmdHis");            header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');            header('Content-Disposition: attachment;filename="' . $title . '.xlsx"');            header('Cache-Control: max-age=0');            // If you're serving to IE 9, then the following may be needed            header('Cache-Control: max-age=1');            // If you're serving to IE over SSL, then the following may be needed            header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past            header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified            header('Cache-Control: cache, must-revalidate'); // HTTP/1.1            header('Pragma: public'); // HTTP/1.0            $objWriter = PHPExcel_IOFactory::createWriter($excel, 'Excel2007');            $objWriter->save('php://output');            return;        }    }

希望以上内容对你有所帮助！如果还有其他问题，请随时提问。 各类知识收集 拥有多年CMS企业建站经验，对 iCMS， Fastadmin， ClassCMS， LeCMS， PbootCMS， PHPCMS， 易优CMS， YzmCMS， 讯睿CMS， 极致CMS， Wordpress， HkCMS， YznCMS， WellCMS， ThinkCMF， 等各类cms的相互转化，程序开发，网站制作，bug修复，程序杀毒，插件定制都可以提供最佳解决方案。