read ( 'content.xml' ) # Start the parse. CharacterDataHandler = char_data zf = zipfile. append ( l ) row = def char_data ( data ): global tabla, row, cell, rept, last_repeat_col, incol if incol : cell += data def read_and_parse ( inFileName ): p = xml. extend ( * ( last_repeat_col - 1 )) elif name = 'table:table-row' : l = copyandtrim ( row, compact ) if l = : row = return tabla. append ( cell ) # print 'append to row %d, col %d : %s' % (len(tabla),len(row),cell) # manage the repeater if last_repeat_col > 1 : row. has_key ( rept ): last_repeat_col = int ( attrs ) else : last_repeat_col = 0 def end_element ( name ): global tabla, row, cell, rept, last_repeat_col, incol, compact, str_strip if name = 'table:table-cell' : if not incol : raise ReadSXCError ( 'double cell end' ) incol = False # add the contents to the row if str_strip : row.

reverse () for i in x : if a = '' : del a else : break return a # 3 handler functions def start_element ( name, attrs ): global tabla, row, cell, rept, last_repeat_col, incol, compact if name != 'table:table-cell' : return if incol : raise ReadSXCError ( 'double cell start' ) incol = True cell = u'' if attrs. Used as an executable, converts files.sxc to csv USAGE: readsxc file.sxc ''' import sys class ReadSXCError ( Exception ): pass import import zipfile tabla = row = cell = u'' rept = u'table:number-columns-repeated' last_repeat_col = 0 incol = False compact = False str_strip = False def copyandtrim ( l, trim ): a = l if trim : x = range ( len ( a )) x. Can be used as a module: it provides the class OOspreadData which is simply a list of lists initialized with the contents of the spreadsheet stored in a (typically. #! /usr/bin/env python # -*- coding: latin1 -*- ''' Read OpenOffice spreadsheets.

Hard return openoffice spread sheet