Re: PHP + DDE live feed

C.F. Scheidecker Antunes wrote:

Hello, I have an Excel spreadsheet that is automatically updated with quotes. I am doing a project for my BS and I need to grab the information from this spreadsheet and populate a MySQL database. Any ideas on how to accomplish that with PHP? The spreadsheet uses a live DDE feed to fetch information from a third party service and needs to be opened. This is not a matter of reading a static XLS spreadsheet but what I need is a DDE way to talk to the open spreadsheet and update the database when the cells are changed or have a 1 minute loop to go over the cells.

There are a few packages on phpclasses.org which may do what you want: http://www.phpclasses.org They all seem to use the COM object (http://www.php.net/com) which only works on windows. This package might help also: http://sourceforge.net/projects/phpexcelreader/ and should work anywhere. -- Postgresql & php tutorials http://www.designmagick.com/