I gave a try at Spreadsheet :
Code: Select all
o1 = App.activeDocument().addObject('Spreadsheet::Sheet','Spreadsheet')
for prop in o1.PropertiesList:
print("{} (<{}>) = {}".format(prop, o1.getTypeIdOfProperty(prop), o1.getPropertyByName(prop)))
returns :
Code: Select all
ExpressionEngine (<App::PropertyExpressionEngine>) = []
Label (<App::PropertyString>) = Spreadsheet002
Label2 (<App::PropertyString>) =
Visibility (<App::PropertyBool>) = True
cells (<Spreadsheet::PropertySheet>) = <PropertySheet object>
columnWidths (<Spreadsheet::PropertyColumnWidths>) = <PropertyColumnWidths object>
rowHeights (<Spreadsheet::PropertyRowHeights>) = <PropertyRowHeights object>
So 'columnWidths', for example, is supposed to contain a PropertyColumnWidths object.
How can we create such an object ?
Code: Select all
o1.columnWidths.__class__
# ---> <class 'Spreadsheet.PropertyColumnWidths'>
Can we create such an object from Spreadsheet module ? :
Typing the dot after Spreadsheet offers nothing interesting.
So, I think Spreadsheet module is not offering any python API for customization.