We are currently working on the forum. For the short-term, all forum content will be in read-only format. We apologize for the interruption and look forward to collaborating with you shortly. All the best in your research!

Excel to XML for rules

Hi Everyone,
I’m trying to create a spreadsheet that will export an XML file that can be uploaded to OC for creating rules. The idea is to define/review the edit specification in Excel and then export to XML for upload. It seems that excel supports the exporting of XML, I just can’t get it to work. I have defined the rules.xsd as the XML map, and it works if I only map a single element (i.e. Target), but when I try and map any additional elements the export does not work. Excel error message of “Cannot save or export XML data. The XML maps in this workbook are not exportable.”

Any ideas or help would be appreciated.


Jeff Yearley
Clinical Data Manager
Department of Pediatrics / IICRC
University of Utah, School of Medicine
P - 801-213-3229
F - 801-587-7616
[email protected]
This discussion has been closed.