By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,591 Members | 629 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,591 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


pbmods
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!
Thanks,
James
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.
thanks..
M.Geis
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.