You can use ODBTP (http://odbtp.sourceforge.net) to connect to it using MS's ODBC driver for Excel. -- bob On Fri, 6 Feb 2004, Griffiths, Daniel wrote: > I dont know any way to actually open and read the file with php, havent come across any classes or methods that will do this. > > My solution when I had this problem was to do it in 2 parts, run a macro on the excel file that will extract the data to a text file and then use php to read that into the db. > > if there is a way to open excel files and read them with php i'd love to know about it. > > > > -----Original Message----- > From: Bruno Pereira [mailto:bruno.pereira@xxxxxxxxxxx] > Sent: 06 February 2004 03:36 > To: php-db@xxxxxxxxxxxxx > Subject: Acessing a excel worksheet from a php site > > > I'm making a site to a company and they have a excel worksheet where i have > to get the data to a site in php. > My question is simple, i think, how can i get it? > > > Cumprimentos > > Bruno Pereira > DSI > bruno.pereira@xxxxxxxxxxx > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
