Read / Modify (Update) data of an Excel Sheet using PHP script

[tsanthoshk]

Hi All

I am trying to read and modify input excel file. when i update the data in excel sheet already existing format is washing out. It mean if excel sheet contain colors those are not appearing once i update.

Can any one suggest links or scripts for this problem.

Requirement: input excel sheet will be given. Read the data and modify with new the data. And the condition is excel sheet contain colors which should not be distrub.


Santhosh Kumar T

[pbmods]

Heya, Santhosh. Welcome to TSDN!

Check out the Spreadsheet_Excel_Writer class.

[tsanthoshk]

Thanks for you reply.

With using Spread sheet writer class we can write the excel sheet i mean creating new excel sheet is possible. But not edit or modify the exist excel sheet is not possible.

I am trying out for a php script which can edit the excel sheet with with disturbing any format of excel sheet.

Santhosh Kumar T

[themaab]

Hello Santhosh,

Did you ever find a solution to update an existing xls file?

I too have ran into the problem where I just would like to update an xls file with formatting already in it.

I've found solutions to create new files as you did.

Your input would be greatly appreciated!
Thanks,
James

[Geis]

Hi all,
I think that perl is a good solution to edit and update excel sheets, even the formula, colors, fonts, etc... you should try it
i didn't find an editing lib in php, but now iam using perl in such cases,
its v helpful.
thanks..
M.Geis

[manderson]

Could someone share what they are using in perl or some sample code? I have approximately 20 spreadsheets where i need to update them.

I have a text file with the old information in the first column and the new information in the 2nd column.