Setting Cell Formats with xlwt format strings

python python-2.7 xlwt
user2569332 picture user2569332 · Jul 26, 2013 · Viewed 22.4k times · Source

I've looked around for several different xlwt formats for cells, but I can't find a comprehensive list. Excel provides the following options for cell content formatting: (general, number, currency, accounting, date, time, percentage, fraction, scientific, text, special, custom) Obviously custom isn't what I want, but what are the formatting strings for all these different options? For example, I've seen:

date_format = XFStyle()
date_format.num_format_str = 'dd/mm/yyyy'

currency_format = XFStyle()
currency_format.num_format_str = '$#,##0.00'

Is there somewhere I can get a comprehensive list of those formatting strings? The documentation on http://www.python-excel.org/ doesn't have much, and the tutorial at the bottom only seems to have dates.

Answer

user2569332 picture user2569332 · Aug 9, 2013

I've found a list. I was just being stupid about looking for it.
The GitHub project has a list of number format strings here:
https://github.com/python-excel/xlwt/blob/master/examples/num_formats.py

Related questions

python xlutils : formatting_info=True not yet implemented

I've got simple code to copy files with xlutils, xlrd, xlwt (downloaded new libraries from python-excel.org) with not loosing formatting. I've got an error as below: from xlwt.Workbook import * from xlwt.Style import * from xlrd import open_workbook …

Read More
how to write python array (data = []) to excel?

I am writing a python program to process .hdf files, I would like to output this data to an excel spreadsheet. I put the data into an array as shown below: Code: data = [] for rec in hdfFile[:]: data.append(rec) …

Read More
xlwt limiting the number of rows

I got the error below when I run the python tool to create an xls file by reading an xml file. How do I fix it? ValueError: row index (65536) not an int in range(65536) File "D:\Zipfiles\Script_try.py", …

Read More