read and write on MS Excel file
Posted: Mon Oct 18, 2004 9:54 pm
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
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