When using Excel spreadsheets, exporting images from table cells is a common data processing operation, which facilitates independent editing, modification, and cropping of the images, and also reduces the size of the Excel spreadsheet file. If there are dozens of worksheet files in xls, xlsx, and other formats, each containing a large number of images, saving the images by opening the files one by one would take an incalculable amount of time. The following introduces how to batch export all images from fifty Excel spreadsheet files to a specified folder at once.
1. Use Cases
Exports all types of images contained in cells of xlsx or xls spreadsheet files as jpg format.
2. Preview
Before processing:
After processing:
3. Steps
Open【 HeSoft Doc Batch Tool 】, select 【Excel Tools】 - 【Export Images from Excel Cells】.
【Add Files】 adds one or more xlsx or xls files from which cell images need to be exported.
【Import Files from Folder】 imports a folder containing a large number of xlsx or xls files from which cell images need to be exported.
You can also drag and drop files directly into the area below. Then click Next.
Here, for 【File Name Type】, select the system default, or you can choose to use the contents of a specific column's cells as the image file names in sequence.
After the process is complete, click the save location to view the exported image files.
