On 4/16/2023 9:01 AM, Alan Gauld wrote:
在 2023/4/15 2:33, angela vales 写道:
I have recently created a tkinter app and need the ability to copy and
paste data from tksheet table into an Excel file.
First thanks for drawing my attention to tksheet. I've long
been desiring a decent table widget in tkinter and was on the
verge of trying to create one of my own. tksheet looks like
it will do all I need.
As to copy/paste I couldn't see any explicit mention but
it does say the underlying data is in a Tk Canvas so it may
be that copy/paste will just work, did you try it? What
happened if you paste into a text editor in the first
instance? And Excel in the second?
If all else fails you can probably write handlers and bind
to Ctrl-C and Ctrl-V to do something yourself that mimics
cut/paste.
I have not used tksheet, but in its documentation at
https://github.com/ragardner/tksheet/wiki#14-getting-selected-cells,
there is the method
get_currently_selected()
Returns namedtuple of (row, column, type_) e.g. (0, 0, "column")
type_ can be "row", "column" or "cell"
There are companion methods for rows, columns, etc. That would be a
good starting point.
--
https://mail.python.org/mailman/listinfo/python-list
