[wxpython-users] grid to clipboard to spreadsheet

[C M]

On Wed, Apr 2, 2008 at 8:05 PM, Randall Smith <randall at tnr.cc> wrote:

> I'd like to take the data in a grid and be able to paste it into a
> spreadsheet.  My current implementation puts csv formatted text into a
> TextDataObject.  The limitation is that the user must go though a data
> import phase and there's no real type preservation.
>
> So the things I'd like to do in order of wishfulness are paste clipboard
> data into spreadsheet:
>
> 1. without import phase
> 2. while preserving some or all types
> 3. without regard to which spreadsheet program is being used
>
> I have noticed that when I copy an html table from firefox and paste it
> into a spreadsheet, there's no prompting from the spreadsheet for formatt=
ing
> the data.  It just pastes into the cells.  So I think that should be
> possible.
>
> BTW, the spreadsheet programs I've been testing are Gnumeric, Open Office,
> and Excel.
>
> Randall
>

Maybe this could be helpful.  Using this kind of grid works for me for
copying and pasting into Excel, though I'm not sure which types you are
referring to (in my case it has times, integers, and text).  I also still
don't know the original author of this class and wish I did (if anyone here
knows, as it is all that person's work):
http://article.gmane.org/gmane.comp.python.wxpython/51644

CM
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.wxwidgets.org/pipermail/wxpython-users/attachments/200804=
03/ec0cf5da/attachment.htm