Use Excel to run calculations

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
atyler
Forum Newbie
Posts: 17
Joined: Tue May 26, 2009 10:28 pm

Use Excel to run calculations

Post 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
Mark Baker
Forum Regular
Posts: 710
Joined: Thu Oct 30, 2008 6:24 pm

Re: Use Excel to run calculations

Post 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
atyler
Forum Newbie
Posts: 17
Joined: Tue May 26, 2009 10:28 pm

Re: Use Excel to run calculations

Post 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
Post Reply