Forum Discussion
excel data to xml - list of lists error
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>
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
