Source code for pyexcel.ext.odsreader

"""
    pyexcel.ext.odsreader
    ~~~~~~~~~~~~~~~~~~~~~~

    Uniform interface for writing different excel file formats

    :copyright: (c) 2011 by Marco Conti
    :license: Apache License 2.0
"""
# Copyright 2011 Marco Conti

# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at

# 	http://www.apache.org/licenses/LICENSE-2.0

# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

# Thanks to grt for the fixes

import odf.opendocument
from odf.table import *
from odf.text import P

[docs]class ODSReader: # loads the file def __init__(self, file): self.doc = odf.opendocument.load(file) self.SHEETS = {} for sheet in self.doc.spreadsheet.getElementsByType(Table): self.readSheet(sheet) # reads a sheet in the sheet dictionary, storing each sheet as an array (rows) of arrays (columns)
[docs] def readSheet(self, sheet): name = sheet.getAttribute("name") rows = sheet.getElementsByType(TableRow) arrRows = [] # for each row for row in rows: row_comment = "" arrCells = [] cells = row.getElementsByType(TableCell) # for each cell for cell in cells: # repeated value? repeat = cell.getAttribute("numbercolumnsrepeated") if(not repeat): repeat = 1 ps = cell.getElementsByType(P) textContent = "" # for each text node for p in ps: for n in p.childNodes: if (n.nodeType == 3): textContent = textContent + unicode(n.data) if(textContent): if(textContent[0] != "#"): # ignore comments cells for rr in range(int(repeat)): # repeated? arrCells.append(textContent) else: row_comment = row_comment + textContent + " "; # if row contained something if(len(arrCells)): arrRows.append(arrCells) #else: # print "Empty or commented row (", row_comment, ")" self.SHEETS[name] = arrRows # returns a sheet as an array (rows) of arrays (columns)
[docs] def getSheet(self, name): return self.SHEETS[name]