In my modest opinion it woul be much easier and faster to export the worksheet as a CSV file and parse the file in PHP than creating a macro in VBA to extract the data to a text file. ----- Original Message ----- From: "Griffiths, Daniel" <daniel.griffiths@xxxxxxxxxxx> To: "Bruno Pereira" <bruno.pereira@xxxxxxxxxxx>; <php-db@xxxxxxxxxxxxx> Sent: Friday, February 06, 2004 9:10 AM Subject: RE: Acessing a excel worksheet from a php site 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
