[SOLVED] read and write on MS Excel file

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
ongray
Forum Newbie
Posts: 14
Joined: Wed Sep 01, 2004 1:08 am

read and write on MS Excel file

Post by ongray »

Hi,
I have this excel file that i desgin to help me calculate the pricing of quotation. It is a quite complex. It consists of a few tables of constants and have a total of 200+ rows.
Anyway, I am trying to keep every quotation into a Database. How can I make use of the current excel file to calculate the pricing? Is there a way for me to write new values into the input CELLs (in excel file) and read the result from the output CELLs?

Regards,
Ray
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

search :arrow: [devnet]excel[/devnet]
ongray
Forum Newbie
Posts: 14
Joined: Wed Sep 01, 2004 1:08 am

Post by ongray »

SOLVED haha... I got it.
http://www.phpbuilder.net/columns/alain ... hp3?page=3
this link give an example on how to do it. It's time for me to try it out.
Thanks anyway. :)
User avatar
phpScott
DevNet Resident
Posts: 1206
Joined: Wed Oct 09, 2002 6:51 pm
Location: Keele, U.K.

Post by phpScott »

the other place you might want to try is http://phpclasses.muddyweb.com/browse/package/86.html
has a nice class to use and a tutorial;
Post Reply