This project has moved. For the latest updates, please go here.

Cell metadata?

May 6, 2015 at 2:21 PM
I'm building an app that reads a data dictionary file and uses ClosedXML to build a fairly complex Excel workbook based on its contents. I need to store some meta-information at the cell level in a number of locations so another tool can later consume the excel file and relate certain cells back to the data dictionary.

I know that OpenXML offers cell level metadata and ExtensionList objects (though I haven't found many concrete examples of how they're used); does ClosedXML offer any kind of metadata mechanism that doesn't involve comments or hidden columns?

Failing that, is there any way to map a ClosedXML cell object directly to its OpenXML equivalent? Otherwise I assume if I have to go the OpenXML-for-metadata route I'll have to save & close the file from ClosedXML and reopen it in OpenXML for a second pass through to apply the metadata.