We operate xlsx files to store a large number of picture url links in multiple columns of cells. In order to obtain information directly from the table more intuitively and quickly and improve the interactivity in the table, we need to convert these picture url links into jpg, png and other formats to preview pictures in the worksheet. When there are multiple columns in the Excel table URL links, but we only need to extract one of the column URL links, how to extract the conversion of the operation alone.
1. Use Scenarios
in xlsx files with many columns with url links of pictures, a fixed column is extracted separately and converted into jpg, png and other format pictures in turn.
For example, in Excel table, there are http web address links in columns A and B. It is necessary to convert column B into picture form. After the conversion is completed, the picture url link in column A remains unchanged, and the picture url link in column B has been converted into a picture corresponding to the link.
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 a fixed column and select the column that needs to convert http URL links into pictures under the column name.
[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 processing to complete, click Save Location to view the 20 Excel spreadsheet files that have been converted.
