Re: PHP parse Excel and Access files

From: 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

« previous php.general (#204702) next »