Search code examples
c#excelexcel-dna

Excel-DNA save custom data into worksheet (not cells)

I'm hoping there is a method to save custom data from an Excel-DNA plugin into the workbook..

Something the user would enter into from a custom Excel-DNA form.

I realize this can be saved into cells, but I don't want the user to see or change the data..

Is there a method of attaching maybe an custom XML file to a workbook, or adding a hidden worksheet?

James

Solution

  • You can do this using Workbook.CustomXMLParts: see
    Custom XML Parts Overview