How to get worksheets from an Excel XLSX spreadsheet in Python

Need to extract the worksheets from inside an Excel spreadsheet? Look no further, as I am about to show you the easy method for getting this done fast.

For this example, we will be using the Cloudmersive Convert API. Let’s begin by installing its client with this command here:

pip install cloudmersive-convert-api-client

Our library contains edit_document_xlsx_get_worksheets, which we can now call with this block of example code:

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.GetXlsxWorksheetsRequest() # GetXlsxWorksheetsRequest | Document input request
try:
# Get worksheets from a Excel XLSX spreadsheet
api_response = api_instance.edit_document_xlsx_get_worksheets(input)
pprint(api_response)
except ApiException as e:
print("Exception when calling EditDocumentApi->edit_document_xlsx_get_worksheets: %s\n" % e)

Once we submit our request object, it will just be a short wait until we have our response containing our individual worksheets. Now, wasn’t that easy?