Setting Cell Formats with xlwt format strings

Question

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.

Also, is there a way to get Excel to dynamically show all the decimals in a float? The currency string suggests the number must match the number of zeros shown after the decimal point. — user2569332
– user2569332, Commented Jul 26, 2013 at 17:20

Elisha · Accepted Answer · 2015-05-08 14:38:10Z

18

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

edited May 8, 2015 at 14:38

Elisha

4,9914 gold badges32 silver badges47 bronze badges

answered Aug 8, 2013 at 22:28

user2569332

5651 gold badge4 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sagar Mehta · Accepted Answer · 2019-12-12 18:05:39Z

1

import time
import datetime
Time = datetime.datetime.now()
Currency = 234

#Format Date
style1 = xlwt.XFStyle()
style1.num_format_str = 'DD-MM-YY'

#Format Currency
style2 = xlwt.XFStyle()
style2.num_format_str = '$#,##0.00'

workbook = xlwt.Workbook()
worksheet = workbook.add_sheet('Sheet1')

worksheet.write(0, 1, Time, style1)
worksheet.write(0, 2, Currency, style2)

edited Dec 12, 2019 at 18:05

answered Jan 7, 2019 at 20:00

Sagar Mehta

4534 silver badges6 bronze badges

Collectives™ on Stack Overflow

Setting Cell Formats with xlwt format strings

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related