# Uses the openpyxl library and xtopdf.
# Author: Vasudev Ram - http://jugad2.blogspot.com
# Copyright 2015 Vasudev Ram.
from openpyxl import load_workbook
from pdfrw import PdfWriter
inp = "C:/Users/eWay/Desktop/aamer/Sample-Sales-Data.xlsx"
out = "C:/Users/eWay/Desktop/aamer/Sample-Sales-Data.pdf"
workbook = load_workbook(inp, guess_types=True, data_only=True)
worksheet = workbook.active
pw = PdfWriter(out)
pw.setFont('Courier', 12)
pw.setHeader('XLSXtoPDF.py - convert XLSX data to PDF')
pw.setFooter('Generated using openpyxl and xtopdf')
ws_range = worksheet.iter_rows('A1:H13')
for row in ws_range:
s = ''
for cell in row:
if cell.value is None:
s += ' ' * 11
else:
s += str(cell.value).rjust(10) + ' '
pw.writeLine(s)
pw.savePage()
pw.close()
