當我運行我的代碼時，它運行良好，并生成了一個名為 exel.xlsx 的 excel 文件，但在 exel.xlsx 中沒有信息。我想我在列出清單時犯了一個錯誤，但我找不到解決方案。def randStr(length=7): characters = list('bcdghijkmnpqrtuvwxyz23456789') shuffle(characters) exel = ''.join(characters[:length]) listb = [exel] listb.append(exel) workbook = xlsxwriter.Workbook('Exel.xlsx') worksheet = workbook.add_worksheet('randomise') chart = workbook.add_chart({'type': 'line'}) expenses = (listb) row = 0 col = 0 workbook.close() return exel
2 回答
躍然一笑
TA貢獻1826條經驗 獲得超6個贊
import xlsxwriter
workbook = xlsxwriter.Workbook('chart_line.xlsx')
worksheet = workbook.add_worksheet()
# Add the worksheet data to be plotted.
data = [10, 40, 50, 20, 10, 50]
worksheet.write_column('A1', data)
# Create a new chart object.
chart = workbook.add_chart({'type': 'line'})
# Add a series to the chart.
chart.add_series({'values': '=Sheet1!$A$1:$A$6'})
# Insert the chart into the worksheet.
worksheet.insert_chart('C1', chart)
workbook.close()
這是 add_chart 的基本方法，然后將值添加到圖表并插入圖表。但是您并沒有為圖表增加任何價值。此外，您沒有向工作表中的列/行添加任何值。我運行了您的代碼，創建了名為“randomise”的工作表，但其中沒有數據，因為您沒有添加任何內容
GCT1015
TA貢獻1827條經驗 獲得超4個贊
解決了！
def randStr(length=7):
characters = list('bcdghijkmnpqrtuvwxyz23456789')
shuffle(characters)
listc=''.join(characters[:length])
return listc
listb=[]
if __name__ == '__main__':
for i in range(20):
value1=(randStr())
listb.append(value1)
workbook = xlsxwriter.Workbook('Exel.xlsx')
worksheet = workbook.add_worksheet('randomise')
worksheet.write_column(0,0,listb)
chart = workbook.add_chart({'type': 'line'})
expenses =(listb)
row = 0
col = 0
workbook.close()
img = makeImage(value1, width=512)
with open('%d.png' % i, 'wb') as f:
f.write(img)
print (i)
添加回答
舉報
0/150
提交
取消