Original link: https://chenyan98.cn/3929.html
Batch renaming of a bunch of pictures may be often used in some scenarios. For conventional renaming by serial number format, appending text, and replacing text, I recommend the batch renaming plug-in in UTools, which is very easy to use. And supports regular expressions. The situation I encountered today is a table at hand. The first column is the name of the person, and the last column is the photo. It is necessary to extract the photo in the last column and name it with the name of the first column. I checked the Internet and realized it with bat. It is useful VBA I realized it, but I didn’t understand it too much after watching it for a while, so I gave up these two methods temporarily. In the process, I thought that it should be easier to implement it with python, but what I thought was not to operate excel directly, but to extract the name to Text document, then extract the pictures in excel by serial number, and finally combine the two of them together, the following are the detailed steps. 1. This step of extracting names is much faster than […]
This article is reprinted from: https://chenyan98.cn/3929.html
This site is for inclusion only, and the copyright belongs to the original author.