<p>我不知道你的数据库里有什么数据。如果你按照下面的例子,你可以</p>
<pre><code>import xlwt
cols = [
['Feedstock', 'None', 'Naphtha', '5.00000', '2005', 'Y'],
['Feedstock', 'None', 'Naphtha', '0.00000', '2006', 'Y'],
['Feedstock', 'None', 'Naphtha', '0.00000', '2007', 'Y'],
['Building Blocks', 'Olefins', 'Ethylene', '5.00000', '2005', 'Y'],
['Building Blocks', 'Olefins', 'Ethylene', '5.00000', '2006', 'Y'],
]
res = {}
for c1, c2, c3, c4, c5, c6 in cols:
res_key = "{}-{}-{}".format(c1, c2, c3)
year_key = "{}-{}".format(c5, c6)
years = {"year": year_key, "value": c4}
res.setdefault(res_key, []).append(years)
title = ["" for _ in range(3)]
_lst = [title]
is_first = True
for info, years in res.items():
rows = [item if not item == "None" else "" for item in info.split("-")]
for item in years:
year = item["year"]
value = int(float(item["value"]))
rows.append(value)
if is_first:
title.append(year)
is_first = False
_lst.append(rows)
book = xlwt.Workbook(encoding='utf8')
sheet = book.add_sheet('untitled', cell_overwrite_ok=True)
for row, rowdata in enumerate(_lst):
for col, val in enumerate(rowdata):
sheet.write(row, col, val)
book.save("test.xls")
</code></pre>