Skillfully use Word Excel to organize Web page pictures in bulk

Often meet this situation, the Web page has a lot of useful pictures of their own material, save the Web page with the way to save the download, in the relevant folder to find the picture material, do not have the rules of the digital name of the picture. If the number of pictures is small, we can open the identification at once, name, but too many, this method is not economical. How about using a better batch name for a picture?

(lots of pictures that need to be renamed)

　　How to use Word Excel to bulk organize Web page picture steps

In fact, we can use Word and Excel tools to change the name of the picture, the operation is slightly more complicated, but if the picture is more, this method is efficient, can save a lot of time.

　1. It is important to clarify the form

Because this page contains a lot of information is not needed, so you can use Word to save the page for editing, forming a more clear form, save as a Word document

　　2. Picture Extraction Super Simple

Now, do not think that in word with such a clear table, you can use the usual way to save as a Web page of the form of the image stripped out, it is not!

In Word 2013, you can save this word file as a PDF file, and then open the PDF file in Word 2013 and save it as a Web page file, so that the picture in the Files folder of the Web page will generate Image001.jpg, Image002.jpg ... Name a regular picture file

　3. picture file name skillfully

So how do you change the filename of the avatar image to the name of the person? You can use Excel tables to achieve this. Copy the first two columns of data from the Word document table to an Excel worksheet, the C2 cell entry "=mid" (A2,search ("", A2) +1,search ("", A2)-search ("", A2)-1) is populated with a downward padding to extract the character name. After you enter "Image001.jpg" in D2, fill it down after entering "=concatenate (C2,". jpg ") in E2 cell, and then populate it with the file name and renamed FileName in the D and E columns.

Next, in the F2 cell, enter the =concatenate ("Ren", "" ", D2," ", E2)" and fill it down.

Finally, copy the data from column F into a text file, save the text file and avatar picture in the same folder, and change its extension to. bat, and then double-click to run it. In this way, the picture file is all translated into Chinese.

Tip: This batch file and avatar image file is best kept in a folder with no Chinese name in the path.