=================================================================================

Adjust each column's width based on the length of the longest string in that column, assign dynamic color in generated PowerPoint slides. The width of the entire table has not been limited. Code:

Before adding the table, we calculate the maximum string length (in characters) for each column, including both the data and the header names. This calculation was done using the applymap(len) function on the DataFrame after converting all data to strings with astype(str), and then taking the maximum with .max().tolist(). Then, we compare these lengths with the header names to ensure the header fits.

max_lengths = df.astype(str).applymap(len).max().tolist()
max_lengths = [max(len(col), length) for col, length in zip(df.columns, max_lengths)]

Using a conversion factor (conversion_factor), we translate these maximum string lengths into inches. This required a bit of trial and error to find a conversion factor that makes the columns neither too wide nor too narrow for the content.

conversion_factor = 0.1
column_widths = [max(Inches(length * conversion_factor), Inches(1)) for length in max_lengths]

Instead of adding the table with a predefined total width, we calculate the total width based on the individual column widths. Then, after the table is created, we set each column's width according to the previously calculated widths.

total_width = sum(column_widths)
table = Slide3.shapes.add_table(rows + 1, cols, left, top, total_width, height).table
for i, width in enumerate(column_widths):
table.columns[i].width = width

===========================================

Dynamic column width adjustments are only applied to columns containing strings longer than 10 characters, and to limit the maximum width of the entire table by introducing conditions to check for string lengths and setting a maximum table width.. Code:

Output:

===========================================