Storing metadata in an Excel workbook

Add-in Express™ Support Service
That's what is more important than anything else

Storing metadata in an Excel workbook
Is there a recommended best practice? 
bobcalco




Posts: 64
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
Posted 28 Dec, 2021 08:10:38 Top
Andrei Smolin


Add-in Express team


Posts: 18183
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
Posted 04 Jan, 2022 06:35:47 Top