Re: PHP & Rading excel files

On Monday 29 September 2003 7:10, BENARD Jean-philippe wrote: > Hi ! > > It's possible to export data to excel (csv, xml, PEAR excel file > writing, ...) but is it possible to import data from excel ? (i.e.: I > want to get the data which is in Cell "A1" of sheet "Toto" in the posted > .xls file). The short answer is "not yet". The PEAR::Spreadsheet_Excel_Writer folks are basically porting over a CPAN perl module. There is currently another perl module for reading Excel files. I _think_ the folks working on the PEAR module will do this one next. I have used the perl module to write a xls2csv.pl script that I exec() from within PHP. That allows my web app to accept Excel files for imports. Surprisingly, even 65,000 rows get converted to csv pretty quick. Now, if you want all the functions and such then you will want to look deeper into the Perl module (or be the one to port it to PHP). -Jackson > > Thanks in advance. > > (o_ BENARD Jean-Philippe - Consultant STERIA Infogérance > (o_ (o_ //\ RENAULT DTSI/ODPS/R@D * ALO * API : MLB 02C 1 14 > (/)_ (\)_ V_/_ 2 Av du vieil étang * 78181 MONTIGNY-LE-BRETONNEUX > Tél : +33 1-30-03-47-83 * Fax : +33 1-30-03-42-10 -- jackson miller cold feet creative 615.321.3300 / 800.595.4401 jackson@coldfeetcreative.com     cold feet presents Emma the world's easiest email marketing Learn more @  http://www.myemma.com