Joined: 10 Nov 2005
|Posted: Tue Mar 21, 2006 12:34 pm Post subject: How to copy from Calc to Writer using Python ?
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.