import openpyxl from openpyxl.workbook import Workbook import datetime outwb = Workbook() wo = outwb.active careerSheet = outwb.create_sheet('career',0) # careerSheet['A1']= datetime.datetime.now() careerSheet.cell(row=1,column=1).value = 'A' careerSheet.cell(row=1,column=2).value = 'B' careerSheet.cell(row=1,column=3).value = 'c' careerSheet.cell(row=2,column=2).value = 20 careerSheet.cell(row=2,column=3).value= 30 careerSheet.append([1,2,3]) careerSheet.append(['This is A1', 'This is B1', 'This is C1']) careerSheet.append({'A' : 'This is A1', 'C' : 'This is C1'}) careerSheet.append({1 : 'This is A1', 3 : 'This is C1'}) outwb.save("sample.xlsx")
python与excel:数组写入到excel
最新推荐文章于 2024-04-30 16:37:31 发布