Open Source Python API for Google Sheets
Python library for writing MS Excel 97/2000/XP/2003 XLS files.
Xlwt is an open source python API for writing and formatting data in older(97/2000/XP/2003 XLS) Microsoft Excel file formats. Python developers can easily manipulating older Microsoft Excel files using this pure Python API with no dependencies on modules and packages outside the standard Python distrubution. The API provides rich writing and manipulating features including, merge cells, format rows, manipulate dates, use hyperlinks, insert images, use panes and more.
Xlwt is pretty easy and simple to use and the developers can install it using the pip package installer. Please note that, the API only supports XLS file format and XLSX file format is currently not supported.
Getting Started with Xlwt
You need to have Python 3.5 or higher installed on your system to run Xlwt smoothly. The recommended way to install via PIP. Please use the following command.
pip install xlwt
Create XLS using Free Python API
Xlwt API allows creating Microsoft Excel XLS file using Python. In order to create a blank excel file you can create an instance using xlwt.Workbook() method. You can add sheets in it using Workbook.add_sheet() method. After you have your new workbook ready, you can add new rows & columns in it accordingly.
Sytle Excel Rows using Python
The Open Source spreadsheet library Xlwt allows software developers to sytle excel rows programatically. You can simply style a row by using Workbook.row().set_style() method. The styling method allows you to set font, font height, color, and more.
Using Panes in XLS via Python
Xlwt library gives developers the capability to freeze rows & columns in XLS fileformat using panes_frozen property. Using the panes properties provided by the API, you freeze specific rows and columns aswell.