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.