#Pdfkit italic install#
#Pdfkit italic update#

# color can either be RGB as I did below, or you can use hex: I did this for illustrative purposes to show some additional features of fpdf. To make this a little more interesting, I change the font color to red when an employee has a title of MANAGER and I also use a blue font color for the first employee printed. I loop through my cursor and start printing the employees to the report (Figure 8). conn = db2.connect()Ĭursor.execute('Select FirstNme, MidInit, LastName, WorkDept, PhoneNo, Job 'įigure 7. I start by connecting to the database, then I define and execute a cursor (Figure 7). With the header and footer in place, I’m ready to start loading the report with data from the employee table. The page number is printed at the center of the page and the date/time is printed at the right. I also print the page number, date, and time. Self.cell(0, 10, 'Page ' + str(self.page_no()) + '/', 0, 0, 'C')įor the footer, I define where on the page it should print and what font I’m using. The report in this example is producing an employee listing from a sample table on my IBM i. The second line of the header contains my column headings to match the columns I’m loading from a Db2 table. Then I specify the tile of the report, Employee listing, and center it on the page. I set the font to Arial 15 and make the text bold. On the first line, I have a logo that is pulled in from a file in the IFS. Self.cell(30, 10, txt = 'Department', border = 1, ln = 0) Self.cell(30, 10, txt = 'First name', border = 1, ln = 0) # width = 40, height = 10, border = 0 (no border), # fpdf.image(name, x = None, y = None, w = 0, h = 0, type = '', link = '') I’ll show each of these and explain what they’re doing. Once I define them in my script, they’re executed automatically for each new page of my report. The fpdf package allows me to set up a header (Figure 5) and footer (Figure 6) for my report. # datetime object containing current date and timeĭt_string = now.strftime('%m/%d/%Y %H:%M:%S')

I’m printing the date and time in the format of month, day, year, hour, minute, second as shown in Figure 4. In addition to using ibm_db and fpdf, I’m also using the datetime module so I can print the date and time in the footer of the report. I start by importing packages I’m using in my script (Figure 3). Now that all packages are installed and up to date, I’m ready to write some code!

#Pdfkit italic install#

To install these packages, I execute the commands in Figure 2 using an SSH terminal like Putty or Mobaxterm. I’m using ibm_db to connect to a Db2 table and fpdf to generate the PDF. Next, I install the packages I’m using in my Python script.

#Pdfkit italic update#

Install and update Python packages (partial listing).