CODEWITHSUNDEEP
phphtmlexcelvba
Martin Petts
Martin Petts

Reputation: 513

Interfacing PHP with an Excel spreadsheet / VBA Script

I have a client that has developed an Excel spreadsheet to calculate various statistics using VBA Script (Excel/VBA is not my forte to say the least). He wants me to create a web front-end for this (I will be using PHP / CakePHP) that will have a simple form for inputting cell values, will query the spreadsheet and return the values for display on the website.

The client does not want to convert the Excel/VBA script to another language - he wants to keep it in a 'silo' and just have the website query the existing script.

Is this possible? Any libraries that can help? How could I go about this?

Upvotes: 0

Views: 2538

Answers (1)

Mark Baker
Mark Baker

Reputation: 212412

You'd need to run MS Excel itself, and use COM... it's the only method of which I'm aware that would allow you to run VBAScript within the Excel workbook from your PHP. You couldn't even use OpenOffice for this, so it limits you to a Windows Server with MS Excel installed

Upvotes: 1

Related Questions