How to convert Legacy XLS (97–03) Spreadsheet to PDF in Python

Sick of having a bunch of old outdated XLS spreadsheets gathering dust? Converting these into PDFs might be a bit more useful, but how difficult might this be to get set up? Well, it’s actually very easy if you have the right API for the job, which is what we are going to be looking into today.

To get us started, we shall install our client using pip install.

pip install cloudmersive-convert-api-client

And to follow this, we call convert_document_xls_to_pdf, which you can see set up in this example I have for you below:

from __future__ import print_functionimport timeimport cloudmersive_convert_api_clientfrom 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.ConvertDocumentApi(cloudmersive_convert_api_client.ApiClient(configuration))input_file = '/path/to/file' # file | Input file to perform the operation on.try:# Convert Excel XLS (97-03) Spreadsheet to PDFapi_response = api_instance.convert_document_xls_to_pdf(input_file)pprint(api_response)except ApiException as e:print("Exception when calling ConvertDocumentApi->convert_document_xls_to_pdf: %s\n" % e)

Alright, we are finished already. It’s time to go pop the champagne, because you just saved yourself hours of coding and headache!

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