漫话python:文件操作

1.文件操作代码s

list={"apple","banana"}
with open('fruit.txt','w',encoding='utf-8')as file:
    for i in list:
        file.write(i+'\n')
with open('fruit.txt','w',encoding='utf-8')as file:
    for i in list:
        print(i.strip())

上面为读写的代码，下面为读的代码，encoding='utf-8'不能变，下面的strip()用于取消结尾的换行符

2.excel操作代码

import openpyxl
dict={
'f1':[苹果派]
'f2':[香蕉片]
}
workbook=openpyxl.Workbook()
sheet=workbook。active
for i,(key,value)in enumerate(dict.items(),start=1):
    t2=value
    sheet.cell(row=i,column=1,value=key)
    sheet.cell(row=i,column=2,value=t2)
workbook.save('excel.xlsx')
workbook=openpyxl.load_workbook('excel.xlsx')
sheet=workbook.active
for row in sheet.iter_rows(min_row=1, max_col=2, values_only=True):  
    print(row) 
workbook.close()