How to convert Excel XLSX to PDF in Python

Let’s make converting Excel files to PDF incredibly simple. All we need is a Cloudmersive API and two snippets of code. First, use pip installer to install our API client.

pip install git+https://github.com/Cloudmersive/Cloudmersive.APIClient.Python.Convert.git

Second, we need to call the function convert_document_autodetect_to_pdf:

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.ConvertDocumentApi(cloudmersive_convert_api_client.ApiClient(configuration))
input_file = '/path/to/file' # file | Input file to perform the operation on.
try:
    # Convert Document to PDF
    api_response = api_instance.convert_document_autodetect_to_pdf(input_file)
    pprint(api_response)
except ApiException as e:
    print("Exception when calling ConvertDocumentApi->convert_document_autodetect_to_pdf: %s\n" % e)

We input our document, and that’s it! Done. The API will determine what type of document it is (supports over 100 file types) and automatically convert it to a PDF.