Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
547 views
in Technique[技术] by (71.8m points)

python - 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

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

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


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...