Applying table style to excel using python

Asked Aug 13 '20 at 13:21

Active Aug 14 '20 at 02:17

Viewed 419 times

I'm trying to apply a style to an excel table using python. I've read this: Apply styles while exporting to 'xlsx' in pandas with XlsxWriter It is not passible to apply a style during the export of a dataframe to excel. I'm trying to open a saved excel file and set the style using openpyxl and tableStyleInfo, but without success.

How can I change a table style?

edited Aug 14 '20 at 02:17

runlevel0

2,715
2
24
31

asked Aug 13 '20 at 13:21

Sergey Zhiltsov

Does this help? https://xlsxwriter.readthedocs.io/working_with_pandas.html – jkr Aug 13 '20 at 13:26
1

Welcome to SO! It is often useful to provide a [minimally reproducible example](https://stackoverflow.com/help/minimal-reproducible-example) of your issue – M Z Aug 13 '20 at 13:37
What have you tried so far? – Charlie Clark Aug 13 '20 at 13:44

Applying table style to excel using python

0 Answers0