due to the often need to transfer to different unit of business, what do you want to be a small tool

At first is to use Excel spreadsheets saved, every time open the query, then in the BBS for help, have a friend using VB to help do a small tool, has been using this yet, but often jammed, can't double click copy all text in the text box, can press enter to confirm (query button can only be the mouse point)

New to Python has a week, want to ask guy to help give a train of thought, can also use this opportunity to learn from the instance (see the video and read really looked at the plenum, use it all forget)

Commonly used form is the

CodePudding user response:

XLRD library used to read excle
Pyqt5 library or tkinter library used to make interface
Also need what idea,,, a little don't understand you are wondering where is the point

CodePudding user response:

Do you want to do a small tool, then enter information in small tools, and then return and display the results, the results can be copied? Little tool backend is the excel file to the query you specify?

CodePudding user response:

Can need not the background excle is best, the appearance of a single file, there is hope to many people used together, information one the inside of the modified information can be updated

CodePudding user response:

Data synchronization, and this takes the database ah,
Can keep excel files in a Shared folder, make sure every user access to the file path, try it, (which I didn't practice)
Thinking, I generally use openpyxl library,
We first press unit name lookup,
Loop through A column, and then use the re regular expressions to match, the match is successful, it outputs corresponding lines,
Then tkinter is used to map interface,
You need to see is
1, openpyxl door access to excel table inside the cell's value,
2, re regular expression usage
The use of the 3, tkinter

CodePudding user response:

Vb to do the best, why want with python