Forum Discussion
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>
4 Replies
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.
