How to save custom data in Excel?

Oct 1, 2013 at 8:31 PM
Hi,

We want to save bunch of custom data in Excel. Does Excel DNA provide any code for it?
I do not think ExcelWorksheet custom property is good for it. Does DNA implement something like IMDEmbeddedData interface?

thanks,

Sherry
Coordinator
Oct 1, 2013 at 9:12 PM
Hi Sherry,

Excel-DNA has no special support for IMDEmbeddedData and it's not something I've ever worked with. It doesn't look like a general data storage mechanism, but rather a specific extension on OLE DB Data Providers to allow Excel to persist the data. The Excel-DNA world is pretty far from this.

What about storing your data in a separate file, like an .mdb?
I think that would be a more standard, and flexible, approach, and with some care your access to the data can be super-fast.

-Govert
Oct 1, 2013 at 9:22 PM
Govert, thanks for your rely, and we will think about your suggestion.