Re: tksheet - Copy and Paste with headers

On 4/14/23 14:33, angela vales wrote: I have recently created a tkinter app and need the ability to copy and paste data from tksheet table into an Excel file. I do have a button for export, but it will be beneficial to also allow the user to simply copy,paste. I have enabled the appropriate

Re: tksheet - Copy and Paste with headers

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

Re: tksheet - Copy and Paste with headers

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

Re: tksheet - Copy and Paste with headers

在 2023/4/15 2:33, angela vales 写道: Hello All, I found this small group in a google search, so not sure if it is still active but giving it a try nonetheless. I have recently created a tkinter app and need the ability to copy and paste data from tksheet table into an Excel file. I do have

Re: TkSheet

On 08/10/2022 07.58, Benny Rieger wrote: What a great work;-) I need a solution for save my tabel as csv. How to do that? Has someone a solution for that? Is this what you're seeking? -- Michael F. Stemper No animals

Re: tkinter: tksheet

On Thu, 17 Jun 2021, Dennis Lee Bieber wrote: FreePascal/Lazarus is supposed to be similar to Delphi, and does have Linux installs -- but I don't know what it provides for database linkages. I do have it installed on my Windows box (the Linux install is HUGE; takes up over 1/4 of the

Re: tkinter: tksheet

On Thu, 17 Jun 2021, Alan Gauld via Python-list wrote: Sounds like a job for a database view. Can you modify the database schema? Could you create a view - even a temporary one just while your app is running? Alan, Yes, created views work well with postgres. Building one for complex,

Re: tkinter: tksheet

On Thu, 17 Jun 2021, Dennis Lee Bieber wrote: My naive idea is to use two queries, one selects * from the company table ordered by nunber, the other by name. The UI offers two radiobuttons when viewing the results, one for each sort column. Presuming all the data fits in memory, it

Re: tkinter: tksheet

On 17/06/2021 00:15, Rich Shepard wrote: > When I view my contacts table it needs to includes attributes from the > company, people, and contacts tables so I can view all prior contacts with > that person. Sounds like a job for a database view. Can you modify the database schema? Could you

Re: tkinter: tksheet

and populate the table and manage all changes (of both view and data) yourself. From an incomplete reading of the tksheet() doc it looks to be the best way to display tables returned by a SQL query. PyQt5 has a QTableView() that does the job, and it works great for a single table, but apparently not so

Re: tkinter: tksheet

On Thu, 17 Jun 2021, dn via Python-list wrote: Use the DBMS by retrieving the data in the desired sequence? dn, Yep. That's what I thought would be the best approach. Thanks, Rich -- https://mail.python.org/mailman/listinfo/python-list

Re: tkinter: tksheet

On Wed, 16 Jun 2021, Dennis Lee Bieber wrote: Scroll further down to "bindings"... rc_insert_row -- a menu binding Dennis, Yes, I saw that one, too. As for sorting, I don't see anything that allows one to add custom events to the bindings... best I can come up with is that

Re: tkinter: tksheet

On 16/06/2021 21:45, Rich Shepard wrote: > The two applications I'm building are both database applications. If > tksheet() is not the most appropriate widget to display database tables what > alternative would be better? I've not used tksheet but it sounds like it might be worth inve

Re: tkinter: tksheet

On 17/06/2021 08.45, Rich Shepard wrote: > On Wed, 16 Jun 2021, Terry Reedy wrote: > >> Somewhat sparse doc at >> https://github.com/ragardner/tksheet/blob/master/DOCUMENTATION.md#5-modifying-table-data >> >> insert_row() > > Terry, > > I'm readi

Re: tkinter: tksheet

On Wed, 16 Jun 2021, Terry Reedy wrote: Somewhat sparse doc at https://github.com/ragardner/tksheet/blob/master/DOCUMENTATION.md#5-modifying-table-data insert_row() Terry, I'm reading this now and saw that. and change the column used for sorting (e.g., sorting by company number or company

Re: tkinter: tksheet

On 6/16/2021 12:31 PM, Rich Shepard wrote: Reading the doc for tksheet tells me that it allows me to modify cells (or entire rows) as well as display them. What I don't see is whether I can add a new row using tksheet Somewhat sparse doc at https://github.com/ragardner/tksheet/blob/master

tkinter: tksheet

Reading the doc for tksheet tells me that it allows me to modify cells (or entire rows) as well as display them. What I don't see is whether I can add a new row using tksheet and change the column used for sorting (e.g., sorting by company number or company name). If you have experience