【1】 Put the next picture under a file directory , Such as E:\SVM_Class\airplanes

【2】 Click on “ Start ”→“ function ”( Or press the shortcut key win+R), Type... In the pop-up box “cmd”, Get into dos interface .

 

【3】dos Command input “e:” enter , Input “cd SVM_Class\airplanes” enter , Go to the picture storage directory , Input “dir /b>a.xls”, Generated in the target file directory excel file a.xls. The picture on the right is generated automatically xls file

【4】 open a.xls, All the picture files are listed , stay excel B1 Enter the file name in “148.jpg”. Mouse selected B1 Cell , And in B1 The bottom right of the column , When the mouse cursor changes to + Time of signal , Drag to make all jpg On the right side of the file B There are file names in all columns .

【5】 Mouse selected C1, And enter the formula :="ren "&A1&" "&B1, Mouse selected C1 Cell , And in C1 The bottom right of the column , When the mouse cursor changes to + Time of signal , Drag to fill as follows . As shown in the figure below :

【6】  Copy c Column contents into Notepad . Notepad saves the file to the picture file “E:\SVM_Class\airplanes” Save notepad and rename it “a.bat”

【7】 The last step , double-click a.ba that will do :

Excel More articles about batch modification of files

  1. excel Batch modify file name

    step : 1. Then copy the column with the standard number to the adjacent blank column 2. Use a square grid so that the leftmost column of the three columns only holds data in the following format : DB37/T or DB37/ 3. Use a square grid to save only the columns in the middle of the three columns in the following format ...

  2. Unix How does timestamp conversion work in Excel Bulk changes ?

    Recently, I came across a Unix The problem of timestamp conversion ."date_time":1393031347 What is this? , You know what? ? If you are right about Unix If you know the time stamp, you can see it at a glance . But we are in the spirit of science popularization ...

  3. Java Realize batch modification of file name

    import java.io.File; import java.util.HashMap; import java.util.Map; import java.util.Map.Entry; /** ...

  4. use SSH Command batch modify folder File permissions and owners

    stay linux System or login ssh You can batch modify file permissions wwwroot The permissions of all directories under the directory are recursively set to 755 cd wwwrootfind -type d -exec chmod 755 {} \; Or is it ...

  5. windows Batch modify the folder name under the environment

    ren 1 A ren 2 B ren 3 C ren 4 D Create a new document on your desktop --->  Batch modify folder name .txt Change the file name to :---> Batch modify folder name .bat As above : double-click ...

  6. Linux Batch modify file and folder owners and permissions

    Linux Two commands are needed to batch modify the owner and permission of files and folders ,chmod as well as chown example : Yes /opt/Oracle/ All files in the directory and subdirectories perform the same permission change : chmod -R 700 /opt ...

  7. ref:ubuntu How to batch modify the file suffix

    ref:https://blog.csdn.net/whuslei/article/details/6724900 ubuntu How to batch modify the file suffix The right way is : Enter... On the command line   renam ...

  8. Win10 How to batch modify the file suffix ?

    Win10 How to batch modify the file suffix ? We usually right-click to rename , however , If there are a lot of files to change , It won't work like this , How to batch modify the suffix ? Now let's take a look at two solutions Usually we modify the file suffix by right clicking >& ...

  9. Batch modify the file coding format to UTF-8

    Batch modify the file coding format to UTF-8 To study the : https://jingyan.baidu.com/article/e8cdb32b47a1ea37042bad11.html http://blog.c ...

Random recommendation

  1. js Are you sure you want to delete

    js Code function confirm_redirect(msg, url) { if (confirm(msg)) { location.href=url; } } html <a hre ...

  2. Apache Server proxy and cache

    Apache Server proxy and cache 1. agent   Forward agency :             Reverse proxy :   mod_proxy modular apache The key modules to implement proxy and gateway . load mod_proxy modular :LoadModu ...

  3. AWK Getting started with handling logs ( turn )

    Preface These two days, I roll up my sleeve to deal with the log , Finally put AWK Here you are . Actually AWK Basic use of , It takes half a day to learn , I used to rely on my colleagues , Inertia . This article is just for beginners , Please don't look around . Here is an example of the log being processed , Not so much ...

  4. WinForm Forms are nested within each other

    As long as the window to be absconded TopLeve Set to Flase Just like a normal control , Added to another form ,TopLeve: Whether it is a top-level window , Here's the code : public partial class TTFor ...

  5. Ajax technology -- Time the test and submit the test paper automatically

    1. summary In the development of network examination system , It is an essential function to time the examination and submit the test paper automatically . Because in the process of answering the paper , The test paper can't be refreshed , So we need to use Ajax Achieve no refresh operation . Run this example , Visit the test preparation page index.jsp, In this page , ...

  6. Design patterns -- Static factory design pattern in android The use of

    I read this article today :http://www.androiddesignpatterns.com/2012/05/using-newinstance-to-instantiate.html public c ...

  7. How to be in ASP.NET Core Web API Use in test Postman

    Use Postman Do a manual test If you are a developer , Testers or managers , When building and using applications , Sometimes I know all kinds of API The method can be a challenge . Use a .NET Core Of Postman For you Web API raw ...

  8. DxPackNet 5. High quality video compression and transmission

    DxPackNet It also provides good support for video compression and decompression , And the system does not need to install a third-party decoder ~ Mainly used  IxVideoEncoder Video encoder   and  IxVideoDecoder Two interfaces It's just Jane ...

  9. Linux Practical cases (4)CentOS Methods to clear user login records and command history

    CentOS Methods to clear user login records and command history Clear log on system success [root@localhost root]# echo > /var/log/wtmp // By default, this file is opened in random code , It can be found ip Wait for the letter ...

  10. Class--2019-04-14

    obtain class object , There are three ways : 1. By class name .class Direct access Class c = Integer.class; 2. adopt Class.forName( Class name ) Function to obtain Class c = Class ...