How to extract excel pictures

There are 3 ways to extract pictures from Excel: Copy and paste into other applications such as Word. Right-click on the image and select "Save as picture." For advanced users, you can use VBA code to extract pictures (requires specifying the PictureIndex parameter).

How to extract pictures from Excel

Method 1: Copy and Paste

• Select the image to be extracted.
• Press "Ctrl C" on your keyboard to copy.
• Open another application (such as Word or PowerPoint).
• Press "Ctrl V" on your keyboard to paste.
• The image will be pasted in picture format.

Method 2: Save as Image

• Right-click the image you want to extract and select "Save as Image".
• In the "Save as type" drop-down list, select the desired image format (such as JPG, PNG, BMP).
• Specify the file save location and click "Save".

Method 3: Using VBA Code (Advanced Method)

• Open the Excel workbook that contains the image.
• Press "Alt F11" on your keyboard to open the Visual Basic Editor.
• In the "Insert" menu, select "Module".
• In the open code window, paste the following code:

Sub ExtractImage(ByVal PictureIndex As Integer)

    With ActiveSheet.Pictures(PictureIndex)
        .Copy
        fileName = "C:\path\to\image.jpg" ' 修改为所需的图像保存路径和文件名
        .Paste Special:=wdPasteEnhancedMetafile
        .Parent.ExportAsFixedFormat Type:=wdExportFormatJPEG, FileName:=fileName, Quality:=100
        .Delete
    End With

End Sub

• Replace the "PictureIndex" parameter in the code with the index number of the image on the worksheet.
• Run the code and the image will be extracted and saved to the specified path and file name.

The above is the detailed content of How to extract excel pictures. For more information, please follow other related articles on the PHP Chinese website!