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
[SOLVED] read and write on MS Excel file
Moderator: General Moderators
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.
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.
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;
has a nice class to use and a tutorial;