'''
ooffice "-accept=socket,host=localhost,port=2002;urp;"
'''

import sys,os
from posta2csv import header, ppp, get_filename

sys.path.append('/usr/lib/openoffice.org2.0/program')

import uno

# get the uno component context from the PyUNO runtime
localContext = uno.getComponentContext()

# create the UnoUrlResolver
resolver = localContext.ServiceManager.createInstanceWithContext(
				"com.sun.star.bridge.UnoUrlResolver", localContext )

# connect to the running office
ctx = resolver.resolve( "uno:socket,host=localhost,port=2002;urp;StarOffice.ComponentContext" )
smgr = ctx.ServiceManager

# get the central desktop object
desktop = smgr.createInstanceWithContext( "com.sun.star.frame.Desktop",ctx)

# access the current writer document
model = desktop.getCurrentComponent()

sheet = model.Sheets.getByIndex(0)
rows = sheet.Rows
columns = sheet.Columns

if __name__ == '__main__':
  fill_sheet(sheet,'st2zx7cp.247')

ctx.ServiceManager