Re: PHP parse Excel and Access files
| From: | Richard Lynch | Date: | Mon, 20 Dec 2004 15:49:06 +0000 |
| Subject: | Re: PHP parse Excel and Access files | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-204702@lists.php.net to get a copy of this message | ||
kioto wrote:
> How to read and get data from Excel Files and Access Files.
> Can you post me articles and tutorials on the web-sites that explain
> the basic concept to create an interface for PHP and this files-type.
> Thanks so much to all.
I believe there is a script on http://phpclasses.org to
read/write ExCel
files... Or, if not, Google for it, and it should turn up. I know they
were using it at my previous job, and they didn't write it themselves. I
pretty much stayed as far away from that MS code as I could, so never knew
where it came from.
Don't know how good it is, even.
You may find it easier and more reliable to have the users export/import
in CSV format instead, as others have noted.
As for MS Access, you could set up a DSN and use http://php.net/odbc to
connect to the database. Please note that MS Access was *not* designed
for multiple connections, and it *will* have difficulties if your script
gets any kind of heavy load (many users) on it.
You may also want to consider OpenOffice as an alternative to these
software products -- you might have better luck finding the internal
formats of OpenOffice files published and more support in the OpenSource
community for software that reads/writes their file formats.
--
Like Music?
http://l-i-e.com/artists.htm