search

dmnfarrell / pandastable

Table analysis in Tkinter using pandas DataFrames.
Other
636 stars 124 forks source link

Copy and Paste Data From Excel #226

Closed nira123 closed 2 years ago

nira123 commented 2 years ago

First time inquiry, please bare with me. Is it possible to directly copy and paste data table from excel to pandastable? I noticed it is working other way around(can copy and paste from pandastable to excel) Thanks

dmnfarrell commented 2 years ago

No you can't though I could probably add it if needed. You can do it in tablexplore.

nira123 commented 2 years ago

Thank you for your reply Damien and appreciate your efforts to develop this awesome module. I am using Pandastable for developing another tool. It would be great if you could make it possible. Could you please kindly add that feature if possible or let me know how coding can be changed to do that.

nira123 commented 2 years ago

Answer given in following link is working for copying data from excel: https://stackoverflow.com/questions/62700469/tkinter-spreadsheet-data-entry Is it possible to bind this function with Ctrl+V in Pandastable or having tab once right click on table left top corner or somewhere as "Paste"?

dmnfarrell commented 2 years ago

This was actually there but only from the toolbar. You can now paste from the clipboard using ctrl-v or the right click menu. This will overwrite the table and won't paste into specific cells though. ctrl-z will undo last change only. If you want custom functionality you can always override the paste method.

nira123 commented 2 years ago

Thanks Damien. I tried upgrading Pandastable. Copy and paste from excel to pandastable is still not working from my end.

dmnfarrell commented 2 years ago

This works for me on windows. Are you sure you upgraded?

nira123 commented 2 years ago

Hmm. Thanks a lot Damien. Not sure why it is not working for me. I am using following code in the answer at the moment: https://stackoverflow.com/questions/62700469/tkinter-spreadsheet-data-entry