RE: [PHP-DB] Acessing a excel worksheet from a php site
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:[EMAIL PROTECTED] > Sent: 06 February 2004 03:36 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] 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 > [EMAIL PROTECTED] > > -- > 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
Re: [PHP-DB] Acessing a excel worksheet from a php site
Check this class: http://sourceforge.net/projects/phpexcelreader/ HTH Ignatius _ - Original Message - From: "Griffiths, Daniel" <[EMAIL PROTECTED]> To: "Bruno Pereira" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, February 06, 2004 10:10 Subject: RE: [PHP-DB] 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:[EMAIL PROTECTED] Sent: 06 February 2004 03:36 To: [EMAIL PROTECTED] Subject: [PHP-DB] 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 [EMAIL PROTECTED] -- 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
RE: [PHP-DB] Acessing a excel worksheet from a php site
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:[EMAIL PROTECTED] Sent: 06 February 2004 09:22 To: Griffiths, Daniel Cc: PHP DB Subject: Re: [PHP-DB] 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" <[EMAIL PROTECTED]> To: "Bruno Pereira" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, February 06, 2004 9:10 AM Subject: RE: [PHP-DB] 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:[EMAIL PROTECTED] Sent: 06 February 2004 03:36 To: [EMAIL PROTECTED] Subject: [PHP-DB] 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 [EMAIL PROTECTED] -- 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
Re: [PHP-DB] 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" <[EMAIL PROTECTED]> To: "Bruno Pereira" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, February 06, 2004 9:10 AM Subject: RE: [PHP-DB] 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:[EMAIL PROTECTED] Sent: 06 February 2004 03:36 To: [EMAIL PROTECTED] Subject: [PHP-DB] 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 [EMAIL PROTECTED] -- 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
RE: [PHP-DB] 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:[EMAIL PROTECTED] Sent: 06 February 2004 03:36 To: [EMAIL PROTECTED] Subject: [PHP-DB] 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 [EMAIL PROTECTED] -- 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-DB] 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 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
