The ability to apply multiple formats to cell with

2019-02-14 08:23发布

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

2条回答
\"骚年 ilove
2楼-- · 2019-02-14 09:03

I have another answer which explains how to apply many formatting styles using openpyxl...

Setting styles in Openpyxl

查看更多
Fickle 薄情
3楼-- · 2019-02-14 09:08

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

查看更多
登录 后发表回答