Improve docs on formatting Excel sheets using xlsxwriter

[Dr-Irv]

Code Sample, a copy-pastable example if possible

N/A

Problem description

I'd like to suggest that the documentation about formatting Excel sheets in the I/O tools page here: https://pandas.pydata.org/pandas-docs/stable/user_guide/io.html?highlight=xlsxwriter#style-and-formatting be improved by putting in a reference to the numerous examples provided by the xlsxwriter documentation here:

https://xlsxwriter.readthedocs.io/pandas_examples.html

I'm willing to do a PR, but I didn't know if there was some reason for not including the external reference on that particular page.

Expected Output

N/A

Output of pd.show_versions()

pandas 0.24.2

[WillAyd]

Makes sense to me - is there something similar for openpyxl?

[Dr-Irv]

@WillAyd I think you can do formatting with openpyxl, but the documentation on how it interacts with pandas is very thin compared to what I pointed to above for xlsxwriter, where they have lots of examples. Didn't see those kinds of examples in the openpyxl docs.

[WillAyd]

Cool thanks for checking! For sure if you have a PR will take a look

…

Sent from my iPhone

On Jul 12, 2019, at 9:33 AM, Irv Lustig ***@***.***> wrote: @WillAyd I think you can do formatting with openpyxl, but the documentation on how it interacts with pandas is very thin compared to what I pointed to above for xlsxwriter, where they have lots of examples. Didn't see those kinds of examples in the openpyxl docs. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.