[B]============= CONTACT DETAILS =============
1 - First Name *:Christian
2 - E-mail *:Christian.Sager@swissageda.info
3 - Telephone:+41 79 276 34 27
4 - Scriptcase License: Christian Sager
============= PROBLEM DATA =============
5 - Description of the problem *:[/B]
The App creates an excel sheet using a template and data from the database. This excel sheet is then sent to the users browser.
Running the script on the development machine (windows 10) gives a proper and expected result (the template is filled with the data from the database). The same script, changing the directory path to the situation on der production server (linux), will only send a file with many error messages(A non-numeric value encountered).
6 - Step by step problem *:
Scriptcase Version 9.4.23, Data Base is MariaDb, The Data on development is dumped from the production server. Excel Template is taken from database, also the data to be filled into the excel sheet . PHPExcel Library uses the one included in Scriptcase. Php on prduction server v7.1.33.
7 -Code snipet:
$objPHPExcel->setActiveSheetIndex(0);
$headerText=‘Content-Disposition:attachment;filename="’.$destFileName.’"’;
header(‘Content-Type:application/vnd.ms-excel’);
header($headerText);
header(‘Cache-Control:max-age=0’);
//create writer
$objwriter=PHPExcel_IOFactory::createWriter($objPHPExcel, ‘Excel5’);
//output to browser
$objwriter->save(‘php://output’);
8 - Urgency
This is part of a larger school administration project and is a necessary part of the functionality
Help or problem resolution is very welcome.