我使用Codeigniter,当我点击导出按钮,然后我得到我的文件下载和下载后,我打开我的Excel工作表,我得到波纹管错误.我测试了下面的代码,它的工作在本地主机.
A PHP Error was encountered
Severity: Warning
Message: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?
Filename: Shared/OLE.php
Line Number: 288
Backtrace:
File: /home/olpz2euas172/public_html/test/application/libraries/PHPExcel/Autoloader.php
Line: 79
Function: _error_handler
File: /home/olpz2euas172/public_html/test/application/libraries/PHPExcel/Autoloader.php
Line: 79
Function: require
File: /home/olpz2euas172/public_html/test/application/libraries/PHPExcel/Writer/Excel5.php
Line: 169
Function: spl_autoload_call
File: /home/olpz2euas172/public_html/test/application/controllers/Report_control.php
Line: 64
Function: save
File: /home/olpz2euas172/public_html/test/index.php
Line: 315
Function: require_once
字符串
我在控制器中使用下面的代码。我从查询中获得正确的数据。
public function export_employee_list(){
$object = new PHPExcel();
$object->setActiveSheetIndex(0);
$table_columns = array("Firstname","Middlename","Lastname","Mobileno","Alternet no","Email Id","Address");
$column = 0;
$object->getActiveSheet()->getStyle('1:1')->getFont()->setBold(true);
foreach($table_columns as $field)
{
$object->getActiveSheet()->setCellValueByColumnAndRow($column, 1, $field);
$column++;
}
$export_list = $this->Report_model->export_employee_list_model();
$excel_row = 2;
foreach($export_list as $row)
{
$object->getActiveSheet()->setCellValueByColumnAndRow(0, $excel_row, $row->firstname);
$object->getActiveSheet()->setCellValueByColumnAndRow(1, $excel_row, $row->middlename);
$object->getActiveSheet()->setCellValueByColumnAndRow(2, $excel_row, $row->lastname);
$object->getActiveSheet()->setCellValueByColumnAndRow(3, $excel_row, $row->mobileno);
$object->getActiveSheet()->setCellValueByColumnAndRow(4, $excel_row, $row->alternateno);
$object->getActiveSheet()->setCellValueByColumnAndRow(5, $excel_row, $row->email_id);
$object->getActiveSheet()->setCellValueByColumnAndRow(6, $excel_row, $row->address);
$excel_row++;
}
$object_writer = PHPExcel_IOFactory::createWriter($object, 'Excel5');
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="Employee list.xls"');
$object_writer->save('php://output');
}
型
1条答案
按热度按时间xdyibdwo1#
只要打开文件在asscopeditor一样notepad++通过ftp后藤相应的行中提到的错误和变化
就您而言
_--------------------------
文件夹:Shared/OLE.php
产品编号:288
_-------------------------
continue;进入continue 2;
真的就这么简单。