Adding tabular data to PDF file by adding table with option and styles using Python ReportLab

We can insert tabular data to PDF file by using platypus SimpleDocTemplate with different styles and options.
Here some of the key options we will be using are rowHeights, colWidths, repeatRows and we can set the style of the table by using setStyle()
We can set the column width for individual columns or we can set common width for all the columns of our table.
Using the setStyle() we can manage the font size , background colour , alignment of text inside the cell etc.
The columns and rows takes the value using a tuple where first element is column and second element is row.
A list can be used to store data with column headers and rows of data. We can also use external sources as data by importing the data file.
Download the source code from here.
www.plus2net.com/python/pdf-t...
Part 1 Creating PDF file and adding text, line , images , water mark etc
• Creating PDF file and ...
Part 2 Generate PDF Mark sheet of students using data from SQLite or MySQL table
• Generate PDF Mark shee...
Part 3 PDF Invoice generation in Python
• PDF Invoice generation...
Part 4 Adding table to PDF file
• Adding tabular data to...
Part 5 Adding database table data to PDF file
• Adding tabular data to...
Part 6 Adding Pandas DataFrame data to PDF file
• Adding pandas datafram...
Part 7 Adding shapes like circle, rectangles
• PDF pages in Python to...
Part 8 Adding bar charts
• Vertical and horizonta...
Part 9 Adding line charts
• Adding line chart to P...
Part 10 Adding Pie Charts
• Pie chart in Python PD...
Part 11 Adding Paragraph
• Adding Paragraph text ...
Part 12 Creating PDF reports
• Creating PDF report by...
#TableInPDF #TabularDataPDF #PDFdataTable #creatingPDFTable #python #reportLab #plus2net

[@ali-mw8nf]

Excellent,,,,,,,,,,,,,,,,,

[@plus2net1]

Many many thanks

[@martinjeaks]

Sir, Your video was greatly helped my programming. One more question for now. How can i add a string (number to word) on the end of the table, means out side the table, just below the table.Thank you sir.

[@plus2net1]

You can get all type of combinations here.
www.plus2net.com/python/pdf-report.php

[@badriinfo259]

that was so helpfull i need one more thing can u help me to print the file created without saviing it

[@maneeshreddy7088]

Can we generate SQL query automatically based on our requirements?

[@plus2net1]

Yes, take the user inputs and then prepare the query. The login system also works in that way. Userid and password as entered by user is used to construct a query and then applied to table to check if matching record is available or not.

[@thomasaadhira]

Sir, can you explain ow to wrap texts inside cells

[@srinivascena485]

Sir what to do when table width exceeds as number of columns were increased ,how to adjust that table with n number of columns in pdf file

[@plus2net1]

You can manage column width like this.
c_width=[0.4*inch,1.5*inch,1*inch,1*inch,1*inch]
t=Table(my_data,rowHeights=20,repeatRows=1,colWidths=c_width)
If you want common width for all columns
c_width=[1*inch]
once you know you have n number of columns then each column width you can manage by using available with / n , this value you can use to set the common width.
You can also manage the margins.

[@guilhermegoncalvesnunes15]

@@plus2net1 and how about to break lines inside the cells?

[@plus2net1]

@@guilhermegoncalvesnunes15 In place of using styles["Normal"] use styles["BodyText"] , this will allow text to align based on width. Please try like this and hope this will work.