Forum Discussion
Solved
excel data to xml - list of lists error
Hello, I'm having trouble exporting my data to xml.
Someone knows how to avoid this or what do I need to do to arrange this?
Excel can only export very simple XML structures with a maximum nesting level of 1. So this is allowed:
<?xml version="1.0" encoding="UTF-8"?>
<title>JKP's Excel pages</title>
<description>Excel Articles at JKP Application Development Services</description>
<link>http://www.jkp-ads.com/Articles/Excelarticles.asp</link>
</xml>
This is not allowed:
<?xml version="1.0" encoding="UTF-8"?>
<channel>
<title>JKP's Excel pages</title>
<description>Excel Articles at JKP Application Development Services</description>
<link>http://www.jkp-ads.com/Articles/Excelarticles.asp</link>
</channel>
</xml>
Does exist a way to make it work? an extensión, macro or something?
VBA would work, you would need to know the structure of the XML to write the code however, this sin't trivial.
- Well thank you very much! :D