Page 1 of 1

EXCEL DATA TO HTML, XML, PHP ?

Posted: Sun Aug 29, 2004 7:24 pm
by TRUCKIN
Dose anyone know how to convert excel data to html, xml, php ? Any info would be helpfull thanks... :D

Posted: Sun Aug 29, 2004 7:27 pm
by feyd
save it as HTML from Excel :)

Posted: Mon Aug 30, 2004 3:31 am
by CoderGoblin
I had to write an import function once - Excel to Postgres DB database. Ended up writing a PERL script to do it using a ParseExcel perl module available on the web. Helped me actually check the data as it was being coverted. The PERL code was called from php.

Posted: Mon Aug 30, 2004 8:47 am
by jakobdoppler
what about thinking about the framework ?

think about saving your excel files as .csv and simply use php's file access/manipulation functions. :-)

_yak

Posted: Mon Aug 30, 2004 9:28 am
by CoderGoblin
CSV and Save as HTML can be useful but depends on the client wishes. It's an extra step many do not want. Often you will get asked "Why can't you take this as it is? NotherCompany would".
The problem is compounded if you have non-technical users.

Posted: Mon Aug 30, 2004 1:52 pm
by TRUCKIN

Posted: Mon Aug 30, 2004 1:55 pm
by markl999
You could just use the CSV file and read it in with http://php.net/fgetcsv then you are free to do what you want with the data, save it as XML, output HTML, store it in a db etc..etc.

Posted: Mon Aug 30, 2004 8:51 pm
by TRUCKIN
Ok i got this so far http://www.i-drum.com/ReadCSV.php

how do i make a template for it and the pics from the zzsound data base should be showing up oh! oh! and what about the links :wink: hehehehe.......

Posted: Tue Aug 31, 2004 5:18 am
by CoderGoblin
If going the CSV route ignore the following....

The module linked to is the module I used with PERL to directly translate an Excel File. Found it really easy apart from one glitch on an old version of Excel (OK was actually OpenOffice) where cell can not be greater than 255 characters. Wasn't a problem for me as data was not that large.