How to get Images from an Excel XLSX Spreadsheet in Python

With a little helping hand from an API, our setup for obtaining images found in Excel files will be an absolute breeze. Here we go.

With pip install, import our client with this command:

pip install cloudmersive-convert-api-client

And now we can call edit_document_xlsx_get_images, the code for which is laid out below.

from __future__ import print_function
import time
import cloudmersive_convert_api_client
from cloudmersive_convert_api_client.rest import ApiException
from pprint import pprint
# Configure API key authorization: Apikey
configuration = cloudmersive_convert_api_client.Configuration()
configuration.api_key['Apikey'] = 'YOUR_API_KEY'
# Uncomment below to setup prefix (e.g. Bearer) for API key, if needed
# configuration.api_key_prefix['Apikey'] = 'Bearer'
# create an instance of the API class
api_instance = cloudmersive_convert_api_client.EditDocumentApi(cloudmersive_convert_api_client.ApiClient(configuration))
input = cloudmersive_convert_api_client.GetXlsxImagesRequest() # GetXlsxImagesRequest | Document input request
try:
# Get images from a Excel XLSX spreadsheet, worksheet
api_response = api_instance.edit_document_xlsx_get_images(input)
pprint(api_response)
except ApiException as e:
print("Exception when calling EditDocumentApi->edit_document_xlsx_get_images: %s\n" % e)

And that’s it. If you enter an XLSX, the images will be extracted by the API and returned to you. It’s as simple as that.