XlsxWriter - A Python module for creating Excel XLSX files XlsxWriter can be used to write text, numbers, formulas and hyperlinks to multiple worksheets and it supports features such as formatting and many more, including: 100% compatible Excel XLSX files. Full formatting. Merged cells. Defined names. Charts. Autofilters. Data validation and drop down lists. Conditional formatting. Worksheet PNG/JPEG images. Rich multi-format strings. Cell comments. Integration with Pandas. Textboxes. Memory optimization mode for writing large files.