Automate Excel with Python and XlsxWriter Part 3: Format Data

Your donation will support me to continue to make more tutorial videos!

XlsxWriter is a Python module for creating Excel XLSX files. That means, the module will work with Excel 2007 and later. And unlike some other Python libraries and modules such as xlwings and win32com that only work on Windows, XlsxWriter is compatible with Mac OS and Linux as well.

From the last tutorial, we learned how to create a simple table with XlsxWriter. In this tutorial we will learning how to format cells.

Python Script

Visit my website

[paulschatzman]

Just what I was looking for. Thank you.

[Mumtaz_GIS_Specialist]

Thank You so much such a series of tutorials..

[comp]

what should I do if I want to clear the data inside an existing table in excel using python?? Note that I don't want to delete the whole table, just its data so that I can write newer data in it.

[kittisakmailbox]

You should use the white background and bigger fonts.