"""
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]