All geek questions in one place

Modifying an Excel worksheet using PHP

I want to modify an existing excel sheet using PHP.

I tried using the pear class Spreadsheet_Excel_Writer. But this class is used to completely create a new excel sheet and write to it.

Is there a way to modify an existing excel sheet using PHP?

+4
source share
2 answers

I really believe that the PHPExcel class can help you, but you may have to read and then rewrite another table. I do not know if the class allows for just modification.

+2
source

A good solution for this is in PHPExcel ... but ... it is not possible to modify an existing file. You must open it, read the data and write the changed data when creating a new excel file.

Its very well-documented access to data is very simple. All separate documentation is intended for reading spreadsheet files.

0
source

Source: https://habr.com/ru/post/1381915/

More articles:


All Articles