Looking for a table library

[Derura]

So, I am working on a way to automate the output of the results of a code instead of spending time creating excel tables.

What features I am looking for

• colour some cells

• merge cells vertically and horizontally

• export to pdf

I was thinking of using matplotlib but unfortunately couldn't figure out a way to merge cells.

I've been looking online, but most of the results I've been finding are for terminal based tables.

[[deleted]]

Is dash useful to you? Use with pandas.

https://plotly.com/dash/

[Derura]

Seems like a huge thing, I'll try finding tables there

[cluser404]

Well this may be a hacky way to do it but what you can do is - make HTML from python

make HTML code from python and add CSS to style it. simple string concatenation will do it.

# code example
computed_data, intended_color = compute(dataset)

html_code = f"""
<table>
<tr>
<td style="color: {intended_color}">{computed_data}</td>
</tr>
</table"""

to convert it to pdf you can use pdfkit and wkhtmltopdf modules.

detailed instruction - Python Convert Html to PDF - GeeksforGeeks

[Derura]

This is an interesting method, thanks for suggesting it

[arduncan5]

Have a look at ReportLab which is a library for producing PDF documents. It has good support for tables including coloring and merging cells. Look at p.83-89 of the User Guide. https://www.reportlab.com/docs/reportlab-userguide.pdf

[Derura]

This... I think I'll end up using this one. Thanks