By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,208 Members | 1,459 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,208 IT Pros & Developers. It's quick & easy.

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

P: 2
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
Dec 13 '07 #1
Share this Question
Share on Google+
5 Replies

Expert 5K+
P: 5,821
Heya, Santhosh. Welcome to TSDN!

Check out the Spreadsheet_Excel_Writer class.
Dec 23 '07 #2

P: 2
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
Dec 28 '07 #3

P: 1
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!
Feb 19 '08 #4

P: 1
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.
Feb 12 '09 #5

P: 1
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.
Aug 30 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.