CODEWITHSUNDEEP
phpexcel
Dumb_Shock
Dumb_Shock

Reputation: 1008

Modifying a Excel sheet using PHP

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

Answers (2)

Bjoern
Bjoern

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

Janis Peisenieks
Janis Peisenieks

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

Related Questions