Each
Example:
# Instantiate a Workbook object workbook = Workbook("CustomProperties.xlsx") # Retrieve a list of all custom document properties of the Excel file customProperties = workbook.getWorksheets().getCustomDocumentProperties()
Property Getters/Setters Summary | ||
---|---|---|
method | getCount() | |
Gets number of items in the collection.
|
||
method | get(index) | |
Returns a |
||
method | get(name) | |
Returns a |
Method Summary | ||
---|---|---|
method | add(name, value) | |
Creates a new custom document property of the PropertyType.Boolean data type.
|
||
method | add(name, value) | |
Creates a new custom document property of the PropertyType.DateTime data type.
|
||
method | add(name, value) | |
Creates a new custom document property of the PropertyType.Float data type.
|
||
method | add(name, value) | |
Creates a new custom document property of the PropertyType.Number data type.
|
||
method | add(name, value) | |
Creates a new custom document property of the PropertyType.String data type.
|
||
method | addLinkToContent(name, source) | |
Creates a new custom document property which links to content.
|
||
method | clear() | |
Removes all properties from the collection.
|
||
method | contains(name) | |
Returns true if a property with the specified name exists in the collection.
|
||
method | indexOf(name) | |
Gets the index of a property by name.
|
||
method | iterator() | |
method | remove(name) | |
Removes a property with the specified name from the collection.
|
||
method | removeAt(index) | |
Removes a property at the specified index.
|
||
method | updateLinkedPropertyValue() | |
Update custom document property value which links to content.
|
||
method | updateLinkedRange() | |
Update custom document property value to linked range.
|
int getCount()
DocumentProperty get(name)
Returns null if a property with the specified name is not found.
name
- The case-insensitive name of the property to retrieve.DocumentProperty get(index)
index
- Zero-based index of the DocumentProperty add(name, value)
name: String
- The name of the property.value: String
- The value of the property.DocumentProperty add(name, value)
name: String
- The name of the property.value: int
- The value of the property.DocumentProperty add(name, value)
name: String
- The name of the property.value: DateTime
- The value of the property.DocumentProperty add(name, value)
name: String
- The name of the property.value: boolean
- The value of the property.DocumentProperty add(name, value)
name: String
- The name of the property.value: float
- The value of the property.DocumentProperty addLinkToContent(name, source)
name: String
- The name of the property.source: String
- The source of the propertyupdateLinkedPropertyValue()
updateLinkedRange()
Iterator iterator()
boolean contains(name)
name: String
- The case-insensitive name of the property.int indexOf(name)
name: String
- The case-insensitive name of the property.remove(name)
name: String
- The case-insensitive name of the property.removeAt(index)
index: int
- The zero based index.clear()