How to copy from Calc to Writer using Python ?

[steve.pole]

Hi all,

in my Python script, I would like to copy an entire spreadsheet table in calc and paste it as an OLE object into a writer document.

My first question: The only to achieve this is to use the clipboard, correct ?

As I understand, I can insert the spreadsheet data into the document as writer table, but then, I have to do all the formatting in the writer doc again that I've done before in the spreadsheet. That's something I would like to avoid.

I have found several examples that copy something within one calc doc here on the forum. I have also found DannyB's examples and helper functions in the 5057, 5058 & 6052 posts, but they seem an overkill for the purpose and before I try to understand what is done there (especially around the dispatcher thing), I would like to know if there isn't a simpler way.

I'm neither a Python nor UNO nor OO.org expert, but looking at the steps required when I do it manually (calc: mark, CTRL-C; writer: CTRL-V), I think this is a trivial task which should have a trivial solution.

Thanks for your time.

CU Z>