How to convert Excel XLSX into JSON in Python
I don’t think anybody has ever been keen about the prospect of coding around format conversions. It’s very dry, but it is quite necessary. To solve this problem, I present to you this lovely API that will allow you to convert between XLSX and JSON without the boring part. Here we go.
Install the client for the API with pip install:
pip install cloudmersive-convert-api-client
Calling convert_data_xlsx_to_json comes next.
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.ConvertDataApi(cloudmersive_convert_api_client.ApiClient(configuration))input_file = '/path/to/file' # file | Input file to perform the operation on.try:# Convert Excel XLSX to JSON conversionapi_response = api_instance.convert_data_xlsx_to_json(input_file)pprint(api_response)except ApiException as e:print("Exception when calling ConvertDataApi->convert_data_xlsx_to_json: %s\n" % e)
And just like that, you can now make your file conversions. It really is that simple. Our APIs offer a ton of other solutions, too. If you need to then convert your JSON into XML, for example, you can apply convert_data_json_to_xml. Same easy process.