Python XlsxWriter - Overview



XlsxWriter is a Python module for creating spreadsheet files in Excel 2007 (XLSX) format that uses open XML standards. XlsxWriter module has been developed by John McNamara. Its earliest version (0.0.1) was released in 2013. The latest version 3.0.2 was released in November 2021. The latest version requires Python 3.4 or above.

XlsxWriter Features

Some of the important features of XlsxWriter include −

  • Files created by XlsxWriter are 100% compatible with Excel XLSX files.

  • XlsxWriter provides full formatting features such as Merged cells, Defined names, conditional formatting, etc.

  • XlsxWriter allows programmatically inserting charts in XLSX files.

  • Autofilters can be set using XlsxWriter.

  • XlsxWriter supports Data validation and drop-down lists.

  • Using XlsxWriter, it is possible to insert PNG/JPEG/GIF/BMP/WMF/EMF images.

  • With XlsxWriter, Excel spreadsheet can be integrated with Pandas library.

  • XlsxWriter also provides support for adding Macros.

  • XlsxWriter has a Memory optimization mode for writing large files.

Advertisements