How to Convert Excel Workbooks to a PDF in Python

Microsoft Excel is the go-to program for organizing large amounts of data using pivot tables, formulas, graphing tools and more. However, the information contained in the documents can be easily damaged by the simplest mis-key. Converting the spreadsheet to a PDF file will ensure the quality and message of your data remains stable when shared with customers or partners.

The following API will assist in transforming all worksheets in your XLSX or XLSB workbook to an easily shareable PDF file.

Image for post
Image for post

Our first step is to run this command to install the SDK:

pip install cloudmersive-convert-api-client

Next, we can call the conversion function with the following 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

The returned result will provide you with a new PDF file with all your data intact. To retrieve your free API key and receive 800 calls/month, simply visit the Cloudmersive website and register for the base account.

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