bobcalco
Posts: 66
Joined: 2019-03-20
|
I'd like to store certain metadata in an Excel workbook. In particular, it would allow my code to persist information external to the workbook but essential to my product, which allows users to associate workbooks with solutions related to my product's main functionality.
I am wondering if there are any best-practice tips/tricks for persisting such information from one use of a workbook to another.
Secondarily I am wondering if Excel API offers storage of custom data inside the xlsx format.
Thanks in advance for any advice.
Sincerely,
Bob |
|
Andrei Smolin
Add-in Express team
Posts: 18830
Joined: 2006-05-11
|
Hello Bob,
You can create a worksheet and set Worksheet.Visible = Excel.XlSheetVisibility.xlSheetVeryHidden. Such a worksheet isn't visible to the user through the UI.
Regards from Poland (CET),
Andrei Smolin
Add-in Express Team Leader |
|