Page 1 of 1
Converting Excel into XML with PHP
Posted: Fri Jan 21, 2011 5:22 am
by Cigana
Hello there, I am fairly new to PHP which is quite inconvenient as I have been asked to implement a script that Exports and Excel file into XML according to certain rules. Does anyone know of a (quite detailed) tutorial that could take me through the process?
Many thanks!
Re: Converting Excel into XML with PHP
Posted: Sun Jan 23, 2011 3:51 pm
by yacahuma
Re: Converting Excel into XML with PHP
Posted: Sun Jan 23, 2011 4:11 pm
by Peec
Re: Converting Excel into XML with PHP
Posted: Tue Jan 25, 2011 7:03 am
by aquariusjanak
Nice posting by you.These links are really very good and are very useful.Thanks for the posting.
Re: Converting Excel into XML with PHP
Posted: Tue Jan 25, 2011 7:22 am
by Cigana
Thanks guys, I found this one which is also pretty nifty:
https://github.com/shancarter/Mr-Data-Converter
The thing I am finding is that these programs struggle with complex Excel spreadsheets. Once I have managed to convert the documents properly I need to write a debug tool which will compare the results of a console output with the xml file and that's another brain scrambler

Any ideas on debugging tool tutorials anyone?
Re: Converting Excel into XML with PHP
Posted: Wed Jan 26, 2011 3:54 am
by Cigana
Peec, this one is really good but PHP seems to be mapping the XML file so that it matches the Excel example, this is what I am finding to difficult to figure out as I am not a PHP programmer I can only understand the overall functionality. Are there scripts out there which offer a more generic solution i.e. being able to nest elements, decide what is an attribute and so on?
Cheers,
Re: Converting Excel into XML with PHP
Posted: Sun Jan 30, 2011 5:58 pm
by Irinij1987
Это просто отличная мысль
Re: Converting Excel into XML with PHP
Posted: Tue Mar 06, 2012 4:44 am
by networkgold4u
This is what I'm looking for
