Regarding Table Generation

[NikhilExactSpace]

There is any method to auto adjust table height and width , if we pass dataset ?

#to generate the table from dataset
def output_df_to_pdf(pdf, df):
    # A cell is a rectangular area, possibly framed, which contains some text
    # Set the width and height of cell
    table_cell_width = 28
    table_cell_height = 8
    cols = df.columns
    render_table_header(df)
    # Loop over to print each data in the table
    for row in df.itertuples():
        if pdf.will_page_break(table_cell_height):
            render_table_header(df)
        for col in cols:
            pdf.set_font('Arial', '', 5)
            value = str(getattr(row, col))
            pdf.cell(table_cell_width, table_cell_height, value, align='C', border=1)
        pdf.ln(table_cell_height)


def render_table_header(df):
    table_cell_width = 28
    table_cell_height = 8
    # Select a font as Arial, bold, 10
    pdf.set_font('Arial', 'B', 8)
    
    # Loop over to print column names
    cols = df.columns
    for col in cols:
        pdf.cell(table_cell_width, table_cell_height, col, align='C', border=1)
    # Line break
    pdf.ln(table_cell_height)

if there any method please let me know.

[Lucas-C]

The table_cell_width / table_cell_height in your code should provide you control over the table celles dimensions.

Here is a full example where those settings are controlled by parameters:

from fpdf import FPDF
import pandas as pd

def output_df_to_pdf(pdf, df, cell_width, cell_height):
    render_table_header(df, cell_width, cell_height)
    for row in df.itertuples():
        if pdf.will_page_break(cell_height):
            render_table_header(df)
        pdf.set_font(style='')
        for col in df.columns:
            value = str(getattr(row, col))
            pdf.cell(cell_width, cell_height, value, align='C', border=1)
        pdf.ln(cell_height)

def render_table_header(df, cell_width, cell_height):
    pdf.set_font('Arial', 'B', 8)
    for col in df.columns:
        pdf.cell(cell_width, cell_height, col, align='C', border=1)
    pdf.ln(cell_height)

df = pd.DataFrame(
    {
        "FirstName": ["Jules", "Mary", "Carlson", "Lucas"],
        "LastName": ["Smith", "Ramos", "Banks", "Cimon"],
        "Age": [34, 45, 19, 31],
        "City": ["San Juan", "Orlando", "Los Angeles", "Saint-Mahturin-sur-Loire"],
    }
)

pdf = FPDF()
pdf.add_page()
output_df_to_pdf(pdf, df, cell_width=32, cell_height=12)
pdf.output("table_with_cells.pdf")

[NikhilExactSpace]

but its fixed cell not dynamic, if one column has more strings then it will not come into next line (except multicell concept- hard to apply).
I want dynamic !

[NikhilExactSpace]

my another approach - but its not good

def gettingWidth(df):
    lst=[]
    colHeaderLen=[]
    for colHeader in df.columns:
        lst.append(colHeader)
    for i in lst:
        length= len(i)
        colHeaderLen.append(length)

    colDataLen = []
    for col in df.columns:
        lst = df[col].tolist()
        colLen = len(col)
        lstLen = []
        for i in lst:
            lstLen.append(int(len(str(i))))
        maxLen = max(lstLen)
        if colLen > maxLen:
            colDataLen.append(colLen)
        else:
            colDataLen.append(maxLen)

    widthList=[]
    for i in range(len(colHeaderLen)):
        if(colHeaderLen[i]>colDataLen[i]):
            if colHeaderLen[i]>100:
                widthList.append(100)
            else:
                widthList.append(colHeaderLen[i])
        else:
            if colDataLen[i]>100:
                widthList.append(100)
            else:
                widthList.append(colDataLen[i])
    return widthList

#to generate the table from dataset
def output_df_to_pdf(pdf, df,table_cell_width ,table_cell_height):
    # A cell is a rectangular area, possibly framed, which contains some text
    # Set the width and height of cell
    #table_cell_width = 24
    #table_cell_height = 7
    widthList= gettingWidth(df)

    cols = df.columns
    render_table_header(df,table_cell_width ,table_cell_height)
    # Loop over to print each data in the table
    pdf.set_fill_color(255)
    pdf.set_text_color(70,76,84)
    pdf.set_font('helvetica', '', 7)
    #pdf.cell(192,10 ,'Efficiency' , align='L', border=1,fill=True)
    #pdf.ln(10)
    for row in df.itertuples():
        if pdf.will_page_break(table_cell_height):
            render_table_header(df,table_cell_width ,table_cell_height)      
        for index, col  in enumerate(cols):
            pdf.set_fill_color(255)
            pdf.set_text_color(0)
            value = str(getattr(row, col))
            pdf.cell(widthList[index]+10, table_cell_height, value, align='L', border=1,fill=True)   
        pdf.ln(table_cell_height)


def render_table_header(df,table_cell_width ,table_cell_height):
    #table_cell_width = 24
    #table_cell_height = 7
    widthList=gettingWidth(df)
    pdf.set_fill_color(240,241,242)
    pdf.set_text_color(70,76,84)
    pdf.set_draw_color(211,217,224)
    pdf.set_line_width(0.3)
    pdf.set_font('helvetica','B',7) 
    # Loop over to print column names
    cols = df.columns
    for index,col in enumerate(cols):
        pdf.cell(widthList[index]+10, table_cell_height, col, align='C', border=1,fill=True)
    # Line break
    pdf.ln(table_cell_height)

[Lucas-C]

Have you checked https://pyfpdf.github.io/fpdf2/Tables.html#recipes?
@RubendeBruin provided a code snippet that does what you are looking for

[NikhilExactSpace]

Already saw this , its not good and also line change in table cell is not there !!

need approach that solve this problem for dataset (auto cell adjust )