Reputation: 1008
I want to modify a already existing excel sheet using PHP.
I tried to use pear class Spreadsheet_Excel_Writer.But this class is used to entirely create a new excel sheet and write in it.
Is there some way i can modify the already existing excel sheet using PHP?
Upvotes: 4
Views: 889
Reputation: 16314
A good solution for this is contained in PHPExcel... but... one can not modify an existing file. You have to open it, read the data, and write the modified data while creating a new excel file.
Its very good documented, accessing the data is very easy. A whole separate documentation is made for reading spreadsheet files.
Upvotes: 0
Reputation: 4998
I do believe, that PHPExcel class can help you out, but you may have to do a read and then a complete rewrite to another spreadsheet. I do not know, if the class allows for just modification.
Upvotes: 2