I have an XML file(1) with structure like which I can open with Excel 2007, edit and save as xml file OK:
<?xml version="1.0"?>
<CONNECTION>
<INVENTORY_STATUS_CODE>None</INVENTORY_STATUS_CODE>
<PRIORITY>2009/07/07 13:18</PRIORITY>
<CONNECTOR_TYPE_NAME>Unspecified</CONNECTOR_TYPE_NAME>
<TRAY_NUMBER>0</TRAY_NUMBER>
<DB_LOSS>0</DB_LOSS>
</CONNECTION>
But when I try to work with XML file(2) with structure like:
<?xml version="1.0"?>
<CONNECTION>
<INVENTORY_STATUS_CODE>None</INVENTORY_STATUS_CODE>
<PRIORITY>2009/07/07 13:18</PRIORITY>
<CONNECTOR_TYPE_NAME>Unspecified</CONNECTOR_TYPE_NAME>
<TRAY_NUMBER>0</TRAY_NUMBER>
<DB_LOSS>0</DB_LOSS>
<GEOMETRIES>
<GEOMETRY>X="123" Y=123"</GEOMETRY>
<GEOMETRY>X="124" Y=124"</GEOMETRY>
</GEOMETRIES>
</CONNECTION>
I could import and edit XML file in Excel but could not export to XML.
It throws an exeption that it could not export due to XML source containing List of lists.
Does anybody have an idea how to import/map/edit/export XML file(2) correctly?
PS: I see two rows per connection in Excel with GEOMETRY column only difference.
Thanks,
Sergiy
Bookmarks