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_functionimport timeimport cloudmersive_convert_api_clientfrom cloudmersive_convert_api_client.rest import ApiExceptionfrom pprint import pprint# Configure API key authorization: Apikeyconfiguration = 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 classapi_instance = cloudmersive_convert_api_client.EditDocumentApi(cloudmersive_convert_api_client.ApiClient(configuration))input = cloudmersive_convert_api_client.GetXlsxImagesRequest() # GetXlsxImagesRequest | Document input requesttry:# Get images from a Excel XLSX spreadsheet, worksheetapi_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.

Image for post
Image for post

Written by

There’s an API for that. Cloudmersive is a leader in Highly Scalable Cloud APIs.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store