Inserting custom XML into an open file: Can it be done?
I want to insert a custom XML part into an Open XML file.Problem: The file is currently open in Microsoft Excel 2007.
Is there any way to do this?
Using XML Mapping, I'm generating an XML file that I want to place inside the Open XML file after an event fires (i.e. the user clicks an export button). However, since the file is open, I don't think it will allow me to perform any functions using the Open XML object model. Creating a copy of the file, modifying it, and saving it doesn't seem like it would be ideal because then I'd have to reload the file in Excel. This would be very disruptive for the user.
What's the division of labor between the Excel 2007 Object Model and the Open XML API? Can the two coexist at all?
Or, do I have to always have to close whatever Office application I'm using before I do anything with the Open XML API?
