1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
#!/usr/bin/env python3
# Script Dependencies:
# openxlsx
# USAGE: ./xlsx2table.py color_srgb.xlsx
import sys
from fpdf import FPDF, FontFace
from fpdf.drawing import color_from_hex_string
from openpyxl import load_workbook
pdf = FPDF()
pdf.add_page()
pdf.set_font("Times", size=22)
wb = load_workbook(sys.argv[1])
ws = wb.active
with pdf.table() as table:
for i, row in enumerate(ws.rows):
style = None
if i > 0:
# We color the row based on the hexadecimal code in the 2nd column:
style = FontFace(fill_color=color_from_hex_string(row[1]))
table.row([cell.value for cell in row], style=style)
pdf.output("from-xlsx.pdf")
|
