from openpyxl import Workbook
#没有excel文件时,需要创建文件对象
wb = Workbook()
#有文件时,打开文件
wb = load_workbook("d://a.xlsx")
#获取当前sheet
ws = wb.active
#新建一个sheet
ws = wb.create_sheet()
#整行输入
ws.append()
#可以append 字典,列表,元组,
添加一行到当前sheet的最底部(即逐行追加从第一行开始)
必须是list,tuple,dict,range,generator类型的。
1,如果是list,将list从头到尾顺序添加。
2,如果是dict,按照相应的键添加相应的键值。
ws.append([‘This is A1’, ‘This is B1’, ‘This is C1’])
ws.append({‘A’ : ‘This is A1’, ‘C’ : ‘This is C1’})
ws.append({1 : ‘This is A1’, 3 : ‘This is C1’})
#保存
ws.save('D://b.xlsx')
python操作excel
最新推荐文章于 2023-04-12 11:29:04 发布