M
M
Maxim2018-12-06 13:51:39
PHP
Maxim, 2018-12-06 13:51:39

Why are curly brackets missing from formulas when saving a file in phpexel?

I do it this way, I created a template, the first sheet is empty, a price is generated in it, in the remaining two sheets of the formula, for an array in exel I press ctrl + shift + enter {}
After the price is generated, the formulas disappear {}

require_once($_SERVER["DOCUMENT_ROOT"].'/upload/documents/Classes/PHPExcel.php');
require_once($_SERVER["DOCUMENT_ROOT"].'/upload/documents/Classes/PHPExcel/IOFactory.php');


$fileType = 'Excel2007';
$fileName = 'empty2.xlsx';

// Read the file
$objReader = PHPExcel_IOFactory::createReader($fileType);
$objPHPExcel = $objReader->load($fileName);



// Write the file
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, $fileType);
$objWriter->save('testFile2.xlsx');

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question