extract text from ods TableCell using odfpy

[frankentux]

Ok. Sorted it out, but only after taking a round trip over
xml.minidom. Here's the working code:

#!/usr/bin/python
from odf.opendocument import Spreadsheet
from odf.opendocument import load
from odf.table import TableRow,TableCell
from odf.text import P
doc = load("/tmp/match_data.ods")
d = doc.spreadsheet
rows = d.getElementsByType(TableRow)
for row in rows[:2]:
    cells = row.getElementsByType(TableCell)
    for cell in cells:
        tps = cell.getElementsByType(P)
        if len(tps) > 0:
            for x in tps:
                print x.firstChild