When doing all kinds of shops or work, you need to preview pictures with worksheets. After collecting pictures using xlsx format files, it is convenient to transmit data. Many pictures in workbook files are replaced by hyperlinks such as url, resulting in only text and links can be seen while previewing files, but no visual pictures can be seen. You also need to open links one by one to view, and then identify and distinguish them, it greatly affects its own efficiency. The following describes how to convert all url links in cells in multiple Excel worksheet files into pictures.
1. Use Scenarios
there are many url links of pictures in xlsx files, which can be converted into visual jpg pictures according to the URL links in turn.
2. Effect preview
before treatment:
after treatment:
3. Operation steps
open 【 HeSoft Doc Batch Tool ], select [Excel Tools]-[Convert Picture Address in Excel to Picture]].
[Add File] Add single or multiple xlsx files that need to be linked and converted to pictures.
[Import File from Folder] Import a large number of folders that need to be linked to xlsx files.
You can also choose to drag files directly below.
[Processing Range] Select all cells.
[Picture Save Location] Select Overlay Cell.
[Fixed picture cell width and height] Enter the width and height of the picture according to your own needs.
after waiting for the processing to complete, click Save Location to view the converted Excel spreadsheet file.
