doc = opendoc('test.ods')
for sheet in doc.sheets:
    print(sheet.name)
cell = sheet['E10']
print(cell.value)
print(cell.value_type)
How do you read a cell's value from an OpenOffice Calc .ods file with python?