I'm using an .XLS spreadsheet to calculate some data, inputting/updating numerous fields with a base value and having excel calculate the sums for me.
I am able to save all the data to a new .XLS file, and all calculations are correct.
When opening the created file, and accessing the cells for the required values a null value is being returned.
$objPHPExcel = PHPExcel_IOFactory::load(ABSPATH .'wp-content/plugins/folder/UKPAYE-2013-2014v1-work-base.xls');
$nowtime = time();
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, "Excel5");
$objReader = new PHPExcel_Reader_Excel5();
$objPHPExcel = $objReader->load(ABSPATH .'wp-content/plugins/folder/UKPAYE-2013-2014-'.$nowtime.'.xls');
$total = $objPHPExcel->getActiveSheet()->getCell('G7')->getCalculatedValue();
The cell that holds the required value is populated from many cells. Some of which contain the following
If this is down to the sums, is it possible to save the data as a flat .xls?