python 操作 libreoffic

import uno

def connect():
    local = uno.getComponentContext()
    resolver = local.ServiceManager.createInstanceWithContext("com.sun.star.bridge.UnoUrlResolver", local)
    context = resolver.resolve("uno:socket,host=localhost,port=2002;urp;StarOffice.ComponentContext")
    desktop = context.ServiceManager.createInstanceWithContext("com.sun.star.frame.Desktop", context)
 
    return desktop
class Calc:

    def __init__(self, file_name = "private:factory/swriter"):
        desktop = connect()
        self.doc = desktop.loadComponentFromURL(file_name, "_blank", 0, ())
        self.sheet = self.doc.getSheets().getByIndex(0)

    def get_dic(self, start, end):
 
        for row in range(start - 1, end):
            value = self.sheet.getCellByPosition(0, row).getString()
            self.sheet.getCellByPosition(1, row).setString("have read")
    def save(self):
        self.doc.store()
def main():
    calc_file = "file:///home/zhangliyong/Desktop/2011.xls"

    calc_obj = Calc(calc_file)
    calc_obj.get_dic(5, 46)
    calc_obj.save()