import csv import glob import os import sys from reportlab.pdfgen import canvas from reportlab.pdfbase import pdfmetrics from reportlab.pdfbase.ttfonts import TTFont from reportlab.lib.pagesizes import A4, landscape from reportlab.lib.units import inch from reportlab.platypus import Table, TableStyle path=os.path.dirname(__file__) sys.path.append(path) os.chdir(path) def main(): pdfmetrics.registerFont(TTFont("Arial-BoldItalic", "Arialbi.ttf")) pdfmetrics.registerFont(TTFont("Calibri-Bold", "Calibrib.ttf")) pdfmetrics.registerFont(TTFont("Calibri", "Calibri.ttf")) width, height = A4 logo="logo2.jpg" StartDate = str(raw_input("Enter Start Date")) EndDate = str(raw_input("Enter End Date")) Dates = StartDate+" - "+EndDate FileNames=[] #CurDir=os.getcwd() pnames = str(os.getcwd())+"\*.csv" names=glob.glob(pnames) for filenames in names: FileNames.append(filenames) CompanyName = str(filenames) sCompanyName=str(os.path.basename(CompanyName))[0:-4].replace("_"," ") CompanyName = str(filenames)[0:-4] c=canvas.Canvas(CompanyName+".pdf",pagesize=landscape(A4)) c.drawImage(logo,500,470, width=3*inch, height=1*inch) c.setFillColorRGB(0.28,0.41,0.49) c.setFont("Arial-BoldItalic", 16) c.drawString(50,500,sCompanyName) c.setFont("Arial-BoldItalic", 11) c.drawString(50,480,Dates) c.setFillColorRGB(0.97,0.58,0.12) c.setFont("Calibri", 11) data=[] csvfile = open(filenames, "rb") reader = csv.reader(csvfile) for row in reader: data.append(row) t=Table(data,colWidths=[0.5*inch,1.1*inch,0.5*inch,1.1*inch,0.8*inch,0.8*inch,0.9*inch,3.7*inch,1*inch]) t.setStyle(TableStyle([("GRID",(0,0),(-1,-1),0.25,(0.0,0.0,0.0),None,(1,1)),("BACKGROUND",(0,0),(8,0),(0.28,0.41,0.49)),("TEXTCOLOR",(0,0),(8,0),(0.97,0.58,0.12)),("FONT",(0,0),(8,0),"Calibri-Bold")])) t.wrapOn(c, width, height) t.drawOn(c, 50, 450) c.setFillColorRGB(0.0,0.0,0.0) c.drawString(50,50,"*Paid Ad Call Logs") c.showPage() c.save() ######################### if __name__ == "__main__": main() # The end =)
Run
Reset
Share
Import
Link
Embed
Language▼
English
中文
Python Fiddle
Python Cloud IDE
Follow @python_fiddle
Browser Version Not Supported
Due to Python Fiddle's reliance on advanced JavaScript techniques, older browsers might have problems running it correctly. Please download the latest version of your favourite browser.
Chrome 10+
Firefox 4+
Safari 5+
IE 10+
Let me try anyway!
url:
Go
Python Snippet
Stackoverflow Question