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/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
