There is a simple mechanism: a file is uploaded to the server, through phpexcel, the data is read into an array, then the template changes certain values ​​in each cell (array), exports a new array to CSV, and provides a link to download it.

Plus: Just

Minus: Document styles are formatted, there are no more closed cells, no merges

Is there a way to read the cell values, but immediately write the changes to the file?

  • 2
    Sure you may. I do not understand what the problem is? First, read the cell, if you are satisfied with the value - go on, if not, write a new value to the cell. You do not know the functions with which to write? Can you attach your code starting from reading the file? - Zhukov Roman
  • At the same time all styles will be saved? - Dvashington
  • one
    Yes, they should, why not? - Zhukov Roman
  • And the united cells will be saved? The thing is, I only found the toarray () method in the specification and I read the file. I did not see anything with live data substitution. And yes, files are always different, they have no specific structure. - Dvashington

0