When creating Excel worksheets, local images are often referenced and inserted into table cells. To reduce the file size of Excel spreadsheets for faster loading, to view images without a network connection, and to facilitate updating and managing images within the workbook, we usually input the disk paths of local images instead of the images themselves. When working with xlsx worksheets, if the local image paths are no longer needed and you want to convert all paths into visual images for easier file previewing, avoiding the need to open them via their paths, what should you do? Below is an introduction on how to convert all local image paths in a large number of Excel spreadsheet files into previewable image formats such as jpg and png.
1. Use Cases
Local disk image file paths within Excel table cells, converting them sequentially into images in formats such as jpg or png based on their file 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 Files】 Add one or more xlsx files that require file path to image conversion.
【Import Files from Folder】 Import a folder containing a large number of xlsx files that need path to image conversion.
You can also directly drag and drop files below
【Processing Range】 Select all cells.
【Image Save Location】 Select overlay cells.
【Fixed Image Cell Width and Height】 Enter the desired image width and height as needed.
After processing is complete, click the save location to view the 100 converted xlsx spreadsheet files.
