Exemple #1
0
def detect(stream):
    """Returns True if given stream is a readable excel file."""
    try:
        opendocument.load(BytesIO(stream))
        return True
    except:
        pass
Exemple #2
0
def detect(stream):
    """Returns True if given stream is a readable excel file."""
    try:
        opendocument.load(BytesIO(stream))
        return True
    except:
        pass
Exemple #3
0
def detect(stream):
    """Returns True if given stream is a readable excel file."""
    try:
        doc = opendocument.load(stream)
        return True
    except:
        return False
Exemple #4
0
def import_set(dset, in_stream, headers=True):
    """Returns dataset from ODS stream. Default sheet 1"""
    dset.wipe()

    doc = opendocument.load(in_stream)
    sheet = doc.spreadsheet.childNodes[0]
    rows = sheet.getElementsByType(table.TableRow)
    row_count = 0
    for row in rows:
        cells = row.getElementsByType(table.TableCell)
        arrCells = []
        cell_count = 0
        for cell in cells:
            # repeated value?
            repeat = cell.getAttribute("numbercolumnsrepeated")
            if(not repeat):
                repeat = 1

            ps = cell.getElementsByType(text.P)
            textContent = ""

            # for each text node
            for p in ps:
                c = p.firstChild  # TODO: Where is it used?
                textContent = textContent + unicode(p)

            if textContent and textContent[0] != "#": # ignore comments cells
                for rr in range(int(repeat)): # repeated?
                    arrCells.append(textContent)
                    cell_count += 1
            else:
                arrCells.append("")

        if row_count == 0 and headers:
            dset.headers = arrCells
        elif cell_count > 1:
            # empty cells are needed, but last string == ['']
            dset.append(arrCells)
        else:
            pass
        row_count += 1
Exemple #5
0
 def __init__(self, file):
     self.doc = opendocument.load(file)
     self.SHEETS = {}
     for sheet in self.doc.spreadsheet.getElementsByType(table.Table):
         self.readSheet(sheet)
Exemple #6
0
 def __init__(self, file):
     self.doc = opendocument.load(file)
     self.SHEETS = {}
     for sheet in self.doc.spreadsheet.getElementsByType(table.Table):
         self.readSheet(sheet)