[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