Web-WF Python Tornado その３（Openpyexcelの紹介） - Qiita

import os import datetime import openpyxl as px from openpyxl.writer.excel import save_virtual_workbook class prtInvoice(tornado.web.RequestHandler): def get(self): # 請求書のtemplateをLoad wb = px.load_workbook(BASE_DIR+u'/template.xlsx') ws = wb.active # 印刷範囲を指定 ws.page_setup.fitToWidth = 1 ws.page_setup.fitToHeight = 0 ws.sheet_properties.pageSetUpPr.fitToPage = True # こんなmodelを準備（実際にはDBなどから model =