code: def readSheet(self, sheet):
          
  
          name = sheet.getAttribute("name")
          rows = sheet.getElementsByType(TableRow)
          arrRows = []
  
          # for each row
          for row in rows:
              row_comment = ""
              arrCells = GrowingList()
              cells = row.getElementsByType(TableCell)
  
              # for each cell
              count = 0
              for cell in cells:
                  # repeated value?
                  repeat = cell.getAttribute("numbercolumnsrepeated")
                  if(not repeat):
                      repeat = 1
                      spanned = \
                          int(cell.getAttribute('numbercolumnsspanned') or 0)
                      # clone spanned cells
                      if self.clonespannedcolumns is not None and spanned > 1:
                          repeat = spanned
  
                  ps = cell.getElementsByType(P)
                  textContent = ""
  
                  # for each text/text:span node
                  for p in ps:
                      for n in p.childNodes:
                          if (n.nodeType == 1 and n.tagName == "text:span"):
                              for c in n.childNodes:
                                  if (c.nodeType == 3):
                                      textContent = u'{}{}'.format(textContent,
                                                                   n.data)
  
                          if (n.nodeType == 3):
                              textContent = u'{}{}'.format(textContent, n.data)
  
                  if(textContent):
                      if(textContent[0] != "#"):  # ignore comments cells
                          for rr in xrange(int(repeat)):  # repeated?
                              arrCells[count]=textContent
                              count+=1
                      else:
                          row_comment = row_comment + textContent + " "
                  else:
                      for rr in xrange(int(repeat)):
                          count+=1
  
              # if row contained something
              if(len(arrCells)):
                  arrRows.append(arrCells)
  
              #else:
              #    print ("Empty or commented row (", row_comment, ")")
  
          self.sheets.append(arrRows)
          self.sheet_names.append(name)
docs: Reads a sheet in the sheet dictionary
  
          Stores each sheet as an array (rows) of arrays (columns)