When we want to export all the pictures in Excel tables, archive them, or use them for other purposes, many people will only manually select the pictures one by one and save them as. When we encounter hundreds of pictures or hundreds of Excel files, they will not be able to save them for a few days. Here are three ways to export pictures in Excel in batch, and you can also specify a column in the table as the picture name automatically named. Fully automated processes, free your hands!
In our daily work and life, we often encounter a situation in which all the pictures in the Excel form are extracted and the information corresponding to the picture is named as the file name.
For example, a company's employee information form, or a school's student roster, these forms generally contain basic personal information and identification photos. We need to batch export everyone's photos to the computer and use their names as the picture names for easy uploading to other systems.
In addition, the e-commerce industry often uses tables to record product information and product maps. In many cases, all product pictures need to be exported to the computer in batches and automatically named according to the product name. Or a large number of reimbursement bills are inserted into the table, and these bills need to be exported in batches and named by the reimbursement person or reimbursement document number.
Anyone can save pictures manually and rename them, but if the number of files is very large, saving them one by one will undoubtedly take time and effort. Therefore, we must learn how to export Excel pictures in batches and bid farewell to this repetitive and meaningless labor.
Batch extract Excel pictures and automatically name the effect preview
before treatment:
after treatment:
method one: use HeSoft Doc Batch Tool
recommended Index:★★★★★
Advantages:
you can export all pictures in Excel tables with one click, and you can also export pictures in batches from hundreds of Excel files.
You can customize the image name. The exported image can use the default name or specify a column as the image name.
Simple operation, no code, no script, just a few mouse clicks can be easily done.
Disadvantages:
it needs to be installed on a computer and only supports Windows systems.
Operation steps:
1, open. HeSoft Doc Batch Tool , select Excel Tools → Export pictures in Excel cells.
2. Add all Excel files, which can be added manually or directly dragged in.
3. Select the cell content of a column as the file name, and then specify the column according to your own needs. Let's take Column A as an example.
4. After the processing is completed, directly click the save location to view. The pictures in the Excel table are exported and automatically named after the cell contents in column A.
Method two: Excel save as html page
recommended Index:★★★☆ ☆
advantages:
without the aid of other tools, Excel comes with the function of exporting to html web pages, simple and direct.
No network is required. If other software is not allowed to be installed on the computer, or the company's internal network, this method is better.
Disadvantages:
the name of the export image is image001 or image002 by default, and cannot be named according to the content.
Operation steps:
open the Excel file, click File → Save As, and select the html web page format. Then a folder with the same name will be automatically generated, and all pictures will be saved in the folder. Just change the name of the picture manually one by one.
Method 3: Use VBA macro to export and automatically name
recommended Index:★★★☆ ☆
advantages:
it can export all pictures in Excel form with one click, and also supports batch processing of multiple files with high degree of automation.
While exporting the picture, you can automatically rename the picture according to the cell content without manual operation.
No other tools are needed, open the VBA macro directly in Excel, and paste the code to automatically export the picture.
Disadvantages:
the operation is more difficult, because it involves code, people who do not understand it are easy to make mistakes and cause other troubles.
Operation steps:
1. First put the Excel file to extract the picture into the same folder, and then create a new Excel file in. xlsm format.
2. Open this xlsm file, press Alt F11 to open the VBA editor, click Insert → Module, and then paste the code.
3. Return to Excel, press Alt F8 to select the newly created module, and then run it. Then select the folder where the Excel table is stored, and the macro will automatically help you export the pictures in each Excel file.
