[wxpython-users] grid to clipboard to spreadsheet

Randall Smith randall at tnr.cc
Wed Apr 2 17:05:52 PDT 2008


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 
formatting 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



More information about the wxpython-users mailing list