Page 1 of 1

read and write on MS Excel file

Posted: Mon Oct 18, 2004 9:54 pm
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

Posted: Mon Oct 18, 2004 10:22 pm
by feyd
search :arrow: [devnet]excel[/devnet]

Posted: Tue Oct 19, 2004 4:51 am
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. :)

Posted: Tue Oct 19, 2004 5:10 am
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;