Re: PHP parse Excel and Access files

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux