I met such operations at work every day, I think if I can write a script in python, to solve this problem,
One by one point with the mouse and the keyboard shortcuts are repeated lines of work, feel little sense, but also time-consuming,
BBS experienced friend, please help to solve this problem, I excel is office2019

CodePudding user response:

That you can try:
1. Download the reference pyhook, pywin32 module
2. Study the keyboard and mouse to monitor events
3. According to their own needs abstract into relatively regular events (such as in which position click of the mouse, every time when to close the file, when to open a file, the file where coordinates, such as this, take these problems into a unified abstract regular events to achieve)

CodePudding user response:

What are you doing? Convert XLSX file?
https://blog.csdn.net/weixin_45903952/article/details/104786048

CodePudding user response:

refer to the second floor weixin_45903952 response:

what are you doing? Convert XLSX file?
https://blog.csdn.net/weixin_45903952/article/details/104786048

Yes, I need is to convert the original files directly to XLSX format, watched the connection, you provide is not very good, but I can run this code, and see what the situation is,