时间戳

首页 > 解决方案 > 组合两个列表以创建 Xlsxwriter 行

python - 组合两个列表以创建 Xlsxwriter 行

问题描述

给定两个字符串列表（年份和季度），制作一个这样的 excel 行：

"2001 q1", "2001 q2", ..., "2008 q3", "2008 q4"

这是我到目前为止的代码：

import xlsxwriter
from xlsxwriter import workbook

workbook = xlsxwriter.Workbook('template.xlsx')
worksheet_data = workbook.add_worksheet( "data" )

year = ["2001 ", "2002 ", "2003 ", "2004 ", "2005 ", "2006 ", "2007 ", "2008 "]
quarter = ['q1 ', 'q2 ', 'q3 ', 'q4 ']

for x in year:
    for y in quarter:
        worksheet_data.write_row(
          "A1",       #start cell
          [x + y]
        )

workbook.close()

我需要这个用于客户定制的表格。

有任何想法吗？

标签： pythonfor-loopxlsxwriterworksheet-functionworksheet

解决方案

希望能帮助到你：

import xlsxwriter
from xlsxwriter import Workbook

workbook = xlsxwriter.Workbook('template.xlsx')
worksheet_data = workbook.add_worksheet("data")
data = []

year = ["2001 ", "2002 ", "2003 ", "2004 ", "2005 ", "2006 ", "2007 ", "2008 "]
quarter = ['q1 ', 'q2 ', 'q3 ', 'q4 ']

for x in year:
    for y in quarter:
        data.append(x + y)
worksheet_data.write_row(0, 0, data)
workbook.close()

write_row(0, 0, data)是零索引的，所以这是 A1。

推荐阅读