Exel title have a fixed form, the following figure


Need to do a GUI interface with the corresponding input window (name, class, id, working content, working position, manager this a few input box), I want to enter information in the GUI, and then insert points that the program can automatically me in GUI input information is inserted into the excel, because excel is a data before, so I need every insert in the last line behind the existing data (that is, fails to cover existing data before), because of the name, class, id fixed corresponds to one of these three city, is there any way to do the function of an input link, for example I input the name, the latter two automatic out the corresponding information, I'm the first idea is to do the personal information that part a can import delete database, this can be done when the input to retrieve a result, because there are a lot of people,

CodePudding user response:

Is generally operated by python database
A breakdown, researchers mainly attribute table (you can enter key at the interface between the tone with corresponding personnel information)
Increase of database operations deletion
Finally, export data to excel in

Direct operation excel also has the corresponding repository, it can be used when data volume is not big