In a previous post, I described a tool for editing OpenXML documents from a managed context.
I’ve added three more features for some common tasks:
1. Remove a part
OpenDoc.exe -r <Input file> <Part>
Sample usage scenarios: removing the calculation chain, removing unwanted resources, removing slides, worksheets.
2. Remove all attributes
OpenDoc.exe -t <Input file> <Part> <XPath> removeAttibutes
Sample usage scenarios: fixing corrupt elements.
The attached archive shows a sample usage: repairing an Excel workbook by:
- removing the calcChain.xml part
- removing the calcChain relationship
- removing the shared formulas from cell entries
The batch looks like this:
-t Corruptible.xlsm /xl/worksheets/sheet1.xml //n:sheetData/n:row/n:c/n:f[@t=’shared’] removeAttributes
-r Corruptible.xlsm /xl/_rels/workbook.xml.rels //n:Relationship[@Target=’calcChain.xml’]
-r Corruptible.xlsm /xl/calcChain.xml
@Update 04/22/2010: Fixed but with long file names in batch mode