专业电容层析成像代做网站,无代码应用搭建平台,wordpress数据库配置,在浴室里做的网站这是我的代码,在本地主机上可以很好地使用数据库中的数据生成一个excel文件,但在托管服务器中它会生成一个空白的excel文件#xff1a;// Starting the PHPExcel library$this-load-library(PHPExcel);//$this-load-library(PHPExcel/IOFactory);$objPHPExcel…这是我的代码,在本地主机上可以很好地使用数据库中的数据生成一个excel文件,但在托管服务器中它会生成一个空白的excel文件// Starting the PHPExcel library$this-load-library(PHPExcel);//$this-load-library(PHPExcel/IOFactory);$objPHPExcel new PHPExcel();$objPHPExcel-getProperties()-setTitle(export)-setDescription(none);$objPHPExcel-setActiveSheetIndex(0);// Field names in the first row$fields $query-list_fields();$col 0;foreach ($fields as $field){$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow($col, 1, $field);$col;}//format the column sizes$sheet $objPHPExcel-getActiveSheet();$cellIterator $sheet-getRowIterator()-current()-getCellIterator();$cellIterator-setIterateOnlyExistingCells( true );/** var PHPExcel_Cell $cell */foreach( $cellIterator as $cell ) {$sheet-getColumnDimension( $cell-getColumn() )-setAutoSize( true );}//var_dump($query-result());//die;// Fetching the table data$row 2;foreach($query-result() as $data){$col 0;foreach($fields as $field){$objPHPExcel-getActiveSheet()-setCellValueByColumnAndRow($col, $row, $data-$field);$col;}$row;}$objPHPExcel-setActiveSheetIndex(0);$objWriter PHPExcel_IOFactory::createWriter($objPHPExcel, Excel2007);header(Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet);header(Content-Disposition: attachment;filename01simple.xlsx);header(Cache-Control: max-age0);ob_clean();$objWriter-save(php://output);解决方法:我认为问题与phpexcel无关.我早些时候遇到过类似的问题,后来发现CI的list_fields()函数在某些linux服务器中不起作用.您可以通过静态放置字段名称而不是使用此功能来检查此方面.标签codeigniter,phpexcel,php来源 https://codeday.me/bug/20191026/1937839.html
