def getParameters(self):
parameters = []
table = self.fp.Parameters
row = 2
parameter = getTableValue(table, 'A', row)
while (parameter):
parameters.append(parameter)
row += 1
parameter = getTableValue(table, 'A', row)
return parameters
def _getHeadersByRow_(self, table):
headers = {}
row = 2 # Skip header row
header = getTableValue(table, 'A', row)
while (header):
headers[header] = row
row += 1
header = getTableValue(table, 'A', row)
return headers
def getParametersValues(doc):
table = None
for t in doc.getObjectsByLabel('Parameters'):
if (t.TypeId == 'Spreadsheet::Sheet'):
table = t
break
if (table is None):
return None, None, True
if ((table.get('A1') != 'Parameter') or (table.get('B1') != 'Value')):
logWarning(
"Spreadsheet 'Parameters' doesn't meet layout constraints to serve as parameters table!"
)
logWarning(
"First row must be 'Parameter', 'Value', 'Unit', 'Source' - creating new one."
)
return None, None, True
hasUnit = (table.get('C1') == 'Unit')
hasSource = (table.get('D1') == 'Source')
hasProperty = (table.get('E1') == 'Property')
row = 2
values = []
while (True):
name = getTableValue(table, 'A', row)
if (name is None):
break
value = getTableValue(table, 'B', row)
unit = None
if (hasUnit):
unit = getTableValue(table, 'C', row)
else:
unit = table.get(getCellRef('B', row))
if (hasattr(unit, 'getUserPreferred')):
unit = unit.getUserPreferred()[2]
else:
unit = None
source = None
if (hasSource):
source = getTableValue(table, 'D', row)
property = None
if (hasProperty):
property = getTableValue(table, 'E', row)
values.append([False, source, property, name, value, unit])
row += 1
return table, values, False