Hi,

I'm importing data from XML file to Excel, and in a first time all seems to be working correctly.

But if you save the file and re-open it, the source stops working.

I'm developing a plugin using Excel interop, so I've explored the clases and I noticed that the first time that you import an XML file, XmlMap.Databinding.SourceUrl has the full path, but after open the Excel file, the XmlMap.Databinding.SourceUrl only stores 230 characters from the real source path. And exploring the file as a zip, the connections.xml file is storing correctly the full path.
So I don't know why but when you open an Excel file excel is trimming the SourceUrl to 230 chars and I think that is an incorrect behavior.

Note: I've tested this on Excel 2007 and Excel 2013

regards,

Sergio.

• Edited by Sergiodebst Wednesday, March 25, 2015 1:36 PM Info about Excel versions

I don't have a direct answer, but you may also consider using Power Query add-in to import the XML file. Power Query can create a refreshable connection that can import your XML into the worksheet or Data Model. With easy user interface you can parse the XML and retrieve your data.

The add-in is available for free for Office 2010, 2013 and Office 365 Professional Plus.

Let me know I you want to hear more, or direct you to relevant resources.

• Edited by Gil RavivMicrosoft employee Wednesday, March 25, 2015 3:57 PM

Link to the post in the correct forum:

https://social.msdn.microsoft.com/Forums/en-US/ddaf22e4-bf6d-4ae2-9a13-79a7ee3df371/excel-bug-with-xml-connection-path?forum=os_binaryfile

• Marked as answer by Sergiodebst 11 hours 58 minutes ago
• Edited by Sergiodebst 11 hours 58 minutes ago