Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

The ability to apply multiple formats to cell with xlwt / openpyxl

I plan to use one of 2 libraries below to output excel file in python:

  1. xlwt ( http://www.python-excel.org/ )
  2. 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.

Example

like image 556
Quan Avatar asked Dec 08 '11 09:12

Quan


1 Answers

The svn versions of both xlrd and xlwt have support for "rich text", which is MS jargon for what you want.

like image 178
John Machin Avatar answered Oct 15 '22 10:10

John Machin