Page 1 of 1

Use Excel to run calculations

Posted: Tue May 26, 2009 10:34 pm
by atyler
I have a spreadsheet with some VB and Excel formulas that is very complex and performs many financial calculations.

I want to write an app in php that will send form data to the spreadsheet, probably need to open the SS to perform the calculations, and then read the results back into the php app.

Can somebody point me in the right direction as to the best way to do this? I'm not a php developer, but am going to be by the time this project is completed! :)

Any good resources, tutorials, etc. are much appreciated. I googled around and haven't been able to find what I'm looking for.

Thanks in advance!
AT

Re: Use Excel to run calculations

Posted: Tue Jun 02, 2009 12:31 pm
by Mark Baker
The PHPExcel calculation engine can handle most Excel functions, but I don't know of any tools or libraries that can handle VB

Re: Use Excel to run calculations

Posted: Fri Jun 12, 2009 1:34 pm
by atyler
Thanks. Looking at that, and I think I'll be able to make it work (not without more problems though, so I'm sure I'll be back).

Thanks for the help...much appreciated.

AT