I plan to use one of 2 libraries below to output excel file in python:
- xlwt ( http://www.python-excel.org/ )
- openpyxl ( http://packages.python.org/openpyxl/ )
I tried the first one, most of things seem to be fine but one issue, unfortunately it may not support the ability to apply multiple formats to cell. (see http://groups.google.com/group/python-excel/browse_thread/thread/11c24606d9b2914d)
Is it true?
If yes, does anybody know how to solve it?
E.g it cannot make some words bold, others regular or different font.
The photo below is the example of what I wanna do. You can see Peter in bold and Fernando in regular text style.
I have another answer which explains how to apply many formatting styles using openpyxl...
Setting styles in Openpyxl
The svn versions of both
xlrd
andxlwt
have support for "rich text", which is MS jargon for what you want.