Page 1 of 1

PHP and Excel

Posted: Mon Mar 17, 2003 2:25 pm
by rodrigocaldeira
Hi anyone!

How can I use PHP to read MS Excel files, without using COM module??

Cheers!

Rodrigo Caldeira

Posted: Mon Mar 17, 2003 5:16 pm
by bionicdonkey
you could save the excel files as csv file

Posted: Tue Mar 18, 2003 10:01 am
by rodrigocaldeira
Yes, I see this today, but now Ihave another question.
I create a file.csv and how can I start the download of this file?

I ask this because I create the file and I put the location on my php file pointing to file.csv, but the file content is shown. How could I solve this?


Thanks!

Posted: Tue Mar 18, 2003 3:11 pm
by bionicdonkey
maybe something along the lines of:
header("Content-Disposition: attachment; filename=file.cvs");

have a look around for 'Content-Disposition'

Posted: Wed Mar 19, 2003 7:39 am
by rodrigocaldeira
Hi,

I tried and I got it!!

It's working perferctly!!!!


Thanks

Posted: Wed Mar 19, 2003 8:32 am
by patrikG
phpclasses.org has a variety of classes regarding Excel, even without COM:

http://www.phpclasses.org/search.html?w ... o_search=1

Excel to PHP parser class.

Posted: Fri Apr 04, 2003 4:35 am
by maperen
You can use this script.
http://www.zakkis.ca/products/abc_excelparser/

and get Excel data into the PHP structures.