我已經(jīng)安裝了 openpyxl 模塊，現(xiàn)在我正在嘗試將一些數(shù)據(jù)寫入一個 excel 文件，以這種方式將 excel 文件填充到一張紙中：["01/01/2016", "05:00:00", 3] 進(jìn)入第 1 行，A、B、C 列["01/02/2016", "06:00:00", 4] 進(jìn)入第 2 行，A、B、C 列["01/03/2016", "07:00:00", 5] 進(jìn)入第 3 行，A、B、C 列["01/04/2016", "08:00:00", 6] 進(jìn)入第 4 行，A、B、C 列["01/05/2016", "09:00:00", 7] 進(jìn)入第 5 行，A、B、C 列當(dāng)我嘗試運(yùn)行代碼時，我得到以下結(jié)果：第 1 行，A 列 - 01/05/2016第 1 行 B 列 - 09:00:00第 1 行，第 C - 7 列代碼：import os, sysfrom openpyxl import Workbookfrom datetime import datetimedt = datetime.now()list_values = [["01/01/2016", "05:00:00", 3], ["01/02/2016", "06:00:00", 4], ["01/03/2016", "07:00:00", 5], ["01/04/2016", "08:00:00", 6], ["01/05/2016", "09:00:00", 7]]wb = Workbook()sheet = wb.activesheet.title = "Data"row = 1sheet['A' + str(row)] = "Date"sheet['B' + str(row)] = "Hour"sheet['C' + str(row)] = "Value"for item in list_values: sheet['A' + str(row)] = item[0] sheet['B' + str(row)] = item[1] sheet['C' + str(row)] = item[2] row =+ 1filename = 'Book_3.xlsx'os.chdir(sys.path[0])os.system('start excel.exe "%s\\%s"' %(sys.path[0], filename,))結(jié)果：
1 回答
九州編程
TA貢獻(xiàn)1785條經(jīng)驗(yàn) 獲得超4個贊
您使用的是 =+ 而不是 +=。下面的代碼應(yīng)該可以工作。我還將 sys.path[0] 更改為 os.getcwd() 寫入當(dāng)前工作目錄。還添加了 wb.save，因?yàn)槠渌a沒有產(chǎn)生輸出。
import os, sys
from openpyxl import Workbook
from datetime import datetime
dt = datetime.now()
list_values = [["01/01/2016", "05:00:00", 3],
["01/02/2016", "06:00:00", 4],
["01/03/2016", "07:00:00", 5],
["01/04/2016", "08:00:00", 6],
["01/05/2016", "09:00:00", 7]]
wb = Workbook()
sheet = wb.active
sheet.title = "Data"
row = 1
sheet['A' + str(row)] = "Date"
sheet['B' + str(row)] = "Hour"
sheet['C' + str(row)] = "Value"
for item in list_values:
sheet['A' + str(row)] = item[0]
sheet['B' + str(row)] = item[1]
sheet['C' + str(row)] = item[2]
row += 1
dest_filename = 'Book_3.xlsx'
wb.save(filename = dest_filename)
os.chdir(os.getcwd())
os.system('start excel.exe "%s\\%s"' %(os.getcwd(), filename,))
添加回答
舉報(bào)
0/150
提交
取消