html - Interfacing PHP with an Excel spreadsheet / VBA Script -


I have a client who has developed Excel spreadsheets to calculate various data using VBA script (Excel / VBA) Is of At least say that) I want to create a web front-end (I will use PHP / CakePHP) for this, which will be a simple form of input to cell values, the spreadsheet will be questioned and displayed on the website. Will return the value for

The customer does not want to change the Excel / VBA script in any other language - he wants to put it in a 'silo' and has a website about the query of the current website.

Is this possible? Any library that can help? How can you go about this?

You will need to run MS Excel only, and use COM. This is the only way Regarding I know that you can allow your PHP to run VBAScript within the Excel workbook. I can not use Open Office for this, so it limits you with MS Excel with Windows Server

Comments