How to get columns from a Excel XLSX spreadsheet in Python

We are here today for the ultimate shortcut for extracting column information from Excel files using Python. Let’s dive straight into the thick of things.

Installation of our client goes like this:

pip install cloudmersive-convert-api-client

Next we can go about setting up our function call for edit_document_xlsx_get_columns. As you will see in the following example code block, this involves instantiating an API with a free key.

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.GetXlsxColumnsRequest() # GetXlsxColumnsRequest | Document input requesttry:# Get columns from a Excel XLSX spreadsheet, worksheetapi_response = api_instance.edit_document_xlsx_get_columns(input)pprint(api_response)except ApiException as e:print("Exception when calling EditDocumentApi->edit_document_xlsx_get_columns: %s\n" % e)

And just like that, our task is complete! Here is what our output will look like:

{
"Successful": true,
"Columns": [
{
"Path": "string",
"HeadingCell": {
"Path": "string",
"TextValue": "string",
"CellIdentifier": "string",
"StyleIndex": 0,
"Formula": "string"
}
}
]
}
Image for post
Image for post

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