這是我的代碼,在本地主機上可以很好地使用數據庫中的數據生成一個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;filename="01simple.xlsx"');

header('Cache-Control: max-age=0');

ob_clean();

$objWriter->save('php://output');

解決方法:

我認為問題與phpexcel無關.我早些時候遇到過類似的問題,后來發現CI的list_fields()函數在某些linux服務器中不起作用.您可以通過靜態放置字段名稱而不是使用此功能來檢查此方面.

標簽：codeigniter,phpexcel,php

來源： https://codeday.me/bug/20191026/1937839.html