Re: Acessing a excel worksheet from a php site
| From: | Ricardo Lopes | Date: | Fri, 06 Feb 2004 09:21:37 +0000 |
| Subject: | Re: Acessing a excel worksheet from a php site | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32816@lists.php.net to get a copy of this message | ||
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@conconf.org>
To: "Bruno Pereira" <bruno.pereira@netvoice.pt>; <php-db@lists.php.net>
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:bruno.pereira@netvoice.pt]
Sent: 06 February 2004 03:36
To: php-db@lists.php.net
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
bruno.pereira@netvoice.pt
--
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