jWorkbookProperty()Estimated reading time: 1 minute
The jWorkbookProperty function extracts information from the properties of the workbook.
This function can be used as a standalone function and does not need to be embedded in another function.
For an example of this function, see Lab Create: Inventory Fixed.
|Max 255 char
|Nothing is extracted
Excel Formula Bar Example
|The name of this function.
|This function will return the value of the custom property "Interject_LinkVersion".
Workbook Property List
Native Excel Properties
These are properties that can be extracted using this function. They are native to every Excel workbook and can be edited on the workbook's info page in settings. They can be extracted with the following values (case-insensitive):
Custom Workbook Properties
In addition to the native Excel properties, this function can also extract custom workbook properties. You can add or edit these properties in the Advanced Properties on the workbook's info page in settings. Interject utilizes these custom properties to store information about the workbook. These custom properties are displayed in the Report Library and can be extracted with this function (case-sensitive).