PHPExcel/Reader/Excel2007.php: Undefined index: rId3

[gmoscalu]

I use an Excel 2007 XML file as a template that I open then fill in with data. My log captures the following error:

2017-02-08 18:51:27| 0|generateModirumReportTemplate.php| | 94|Loading excel template file SLA_Report_Template.xlsx | 2017-02-08 18:51:28| 0|/var/www/html/stats/include/PHPExcel/Reader/Excel2007.php| Unknown| 644| Array ( [0] => PHP error raised in file /var/www/html/stats/include/PHPExcel/Reader/Excel2007.php: [err_no] => 8 [err_level] => E_NOTICE [current_errors_enabled] => E_ERROR & E_WARNING & E_PARSE & E_NOTICE & E_CORE_ERROR & E_CORE_WARNING & E_COMPILE_ERROR & E_COMPILE_WARNING & E_USER_ERROR & E_USER_WARNING & E_USER_NOTICE & E_RECOVERABLE_ERROR & E_USER_DEPRECATED [err_str] => Undefined index: rId3 [err_line] => 644 [err_context] => Array

this occurs when loading the template:

$inputFileName = "SLA_Report_Template.xlsx";

log_line(basename(FILE), FUNCTION, LINE, 0,"Loading excel template file $inputFileName "); /** Load $inputFileName to a PHPExcel Object **/ $objPHPExcel = PHPExcel_IOFactory::load($inputFileName);

log_line(basename(FILE), FUNCTION, LINE, 0,"Selecting worksheet 'Volumetry' "); $objPHPExcel->getSheetByName('Volumetry');

Can you please look into it and fix?

Let me know if you need any further info.

BR Gabriel

[michallohnisky]

👍