XLSX を PDF に変換 (openpyxl,reportlab)

openpyxl と reportlab を使って、XLSX を PDF に変換します。
pandas と FPDF を使う例はこちら
XLSX を PDF に変換　(pandas,FPDF)

xlsx_pdf_simple.py

#! /usr/bin/python
#
#	xlsx_pdf.py
#
#					   Feb/03/2019
# ------------------------------------------------------------------
import sys
from openpyxl import Workbook
from openpyxl import load_workbook
from reportlab.pdfbase.cidfonts import UnicodeCIDFont
from reportlab.pdfbase import pdfmetrics
from reportlab.platypus import SimpleDocTemplate, Table, TableStyle
from reportlab.lib.pagesizes import A4
from reportlab.lib import colors
# ------------------------------------------------------------------
# [4]:
def pdf_gen_proc(file_pdf,ws):
	doc = SimpleDocTemplate(file_pdf, pagesize=A4)
	fontname_g = "HeiseiKakuGo-W5"
	pdfmetrics.registerFont(UnicodeCIDFont(fontname_g))
	elements = []
#
	data = []
	for row in ws.rows:
		unit_aa = []
		print(row[0].value)
		for col in row:
			unit_aa.append(col.value)
		data.append(unit_aa)
	tt=Table(data)
	tt.setStyle(TableStyle([('BACKGROUND',(1,1),(-2,-2),colors.cyan),
		('TEXTCOLOR',(0,0),(1,-1),colors.red),
		('FONT', (0, 0), (-1, -1), "HeiseiKakuGo-W5", 20),
		('GRID', (0, 0), (ws.max_column, ws.max_row), 0.25, colors.black),]))
	elements.append(tt)
#
	doc.build(elements)
# ------------------------------------------------------------------
sys.stderr.write("*** 開始 ***\n")
file_xlsx = sys.argv[1]
file_pdf = sys.argv[2]
#
wb = load_workbook(filename = file_xlsx)
ws = wb.active
print("ws.max_row = %d" % ws.max_row)
print("ws.max_column = %d" % ws.max_column)
#
pdf_gen_proc(file_pdf,ws)
#
#
sys.stderr.write("*** 終了 ***\n")
# ------------------------------------------------------------------

実行方法

./xlsx_pdf_simple.py cities.xlsx out01.pdf