When working with xls and xlsx format files, there are many local image paths in the spreadsheet that need to be converted to jpg, png, and other image formats for easier viewing and previewing. What should you do when you need to preserve the local image paths in an Excel spreadsheet while still converting the paths into visually previewable images? The following describes how to batch preview all local image paths in a spreadsheet by overlaying the left or right adjacent cells while retaining the file paths.
1. Use Cases
Preserve local image paths in Excel table cells, and preview the images in an overlay manner to the left or right of the corresponding image paths.
2. Effect Preview
Before processing:
After processing:
3. Operation Steps
Open【 HeSoft Doc Batch Tool 】, select【Excel Tools】-【Convert Image Paths to Images in Excel】.
【Add Files】Add one or more xlsx files for converting local image paths to images.
【Import Files from Folder】Import a folder containing a large number of xlsx files that need local image path to image conversion.
You can also choose to drag and drop files directly below.
【Processing Range】Select all cells.
【Image Saving Position】Choose whether to overlay images from local image paths to the left or right based on your needs.
【Fixed Image Cell Width and Height】Enter the image width and height as needed.
After processing is complete, click the save location to view the twenty converted Excel spreadsheet files.
