SetPropertiesFromWorkbook
- 1 Minute to read
- Print
- DarkLight
- PDF
SetPropertiesFromWorkbook
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Attaches metadata in an excel spreadsheet to existing database objects.
Method
| Key | Value(s) | Description |
|---|---|---|
| method | SetPropertiesFromWorkbook | |
| project | projectname | Project to attach the data to |
| filename | pathandfilename | Path and filename of excel spreadsheet that contains the metadata to be attached. Must include tablename and fieldname as 1st and 2nd columns respectively. |
| properties | [comma separated list of column headers] | The list of properties to attach. Property names must match spreadsheet column headers, order of columns is not important other than tablename and Filename. Tablename and fieldname do not need to be included in the properties list. |
| delimiter | delimiter | Optional. The delimiter to use in the categories list. Default is comma. |
Sample File Layout
Example
{
"method": "SetPropertiesFromWorkbook",
"filename": "%DATAPATH%RegressionTest/FieldPropertiesWorkbook.xlsx",
"properties": [
"Description",
"Categories"
],
"project": "Demonstration"
}
Was this article helpful?