EXCEL DATA TO HTML, XML, PHP ?
Moderator: General Moderators
EXCEL DATA TO HTML, XML, PHP ?
Dose anyone know how to convert excel data to html, xml, php ? Any info would be helpfull thanks... 
- CoderGoblin
- DevNet Resident
- Posts: 1425
- Joined: Tue Mar 16, 2004 10:03 am
- Location: Aachen, Germany
-
jakobdoppler
- Forum Commoner
- Posts: 46
- Joined: Wed May 21, 2003 6:16 pm
- CoderGoblin
- DevNet Resident
- Posts: 1425
- Joined: Tue Mar 16, 2004 10:03 am
- Location: Aachen, Germany
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.
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
hehehehe.......
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
- CoderGoblin
- DevNet Resident
- Posts: 1425
- Joined: Tue Mar 16, 2004 10:03 am
- Location: Aachen, Germany
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.