I have been working with Xml files in Excel for some time now, and thought it is time to share some observations. [Read more…] about Excel and XML: four observations and two bugs
XPath
Get XPaths from workbook – update
In Get XPath objects from Excel workbook I described a method to retrieve all mapped XPaths from a workbook. In this post I describe another method, using the Worksheet.XmlMapQuery function. It’s simpler, and faster.
[Read more…] about Get XPaths from workbook – updateGet XPath objects from Excel workbook
When working with XML enabled workbooks the relevant objects and properties are easy to retrieve. Unfortunately a workbook has no built-in collection of XPath objects. How can we get a list of all XPath objects in a workbook? [Read more…] about Get XPath objects from Excel workbook