When there are too many local image paths in an xlsx file, leaving them unattended for a long time may cause the image paths in the spreadsheet to become invalid after we rename or move the image files while organizing computer files. Moreover, as the number of images increases, management becomes very complicated, and local files can easily become disorganized. When we only need to preview one of the many columns of paths in a large number of spreadsheets as images to enhance the visualization effect of the Excel file, how can we perform this quickly and in batch?
1. Use Cases
In an xlsx file with multiple columns containing local image paths, convert a specific column of local image paths into corresponding jpg, png, or other image formats.
For example: A table contains cells in columns A, B, and C with local image paths. You need to convert column B into images. After conversion, the image paths in columns A and C remain unchanged, while column B has been converted into images based on the paths.
2. Preview
Before processing:
After processing:
3. Steps
Open HeSoft Doc Batch Tool , select [Excel Tools] - [Convert Image Addresses to Images in Excel].
[Add File] to add one or more xlsx files that need file paths converted to images.
[Import Files from Folder] to import a folder containing a large number of xlsx files that need path-to-image conversion.
You can also directly drag and drop files into the area below.
[Processing Range] select a fixed column, then choose the column name below where you want to convert the local image paths to images.
[Image Save Location] select Overwrite Cell.
[Fix Image Cell Width and Height] enter the desired image width and height based on your needs.
After processing is complete, click save location to view the converted Excel table files (over thirty files).
