thats asuming the data is in a nice table that will go into the db easily, and if it is then there must of been some process to getting it like that as its simply not the easiest way for people to work due to the massive amount of duplication, if its a typical spreadsheet cross tab then that won't work as you have no control over the data. what sort of data is in the excel files? -----Original Message----- From: Ricardo Lopes [mailto:lopes@xxxxxxxxxxxxxxx] Sent: 06 February 2004 09:22 To: Griffiths, Daniel Cc: PHP DB Subject: Re: Acessing a excel worksheet from a php site 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
