from openpyxl import Workbook, load_workbook
import os
classDo_Excel:def__init__(self, filename, sheetname='Sheet'):
self.filename = filename
self.sheetname = sheetname
defwrite(self, i, j, value):ifnot os.path.exists(self.filename):
wb = Workbook()
sh = wb.create_sheet(self.sheetname)else:
wb = load_workbook(self.filename)
sh = wb[self.sheetname]
sh.cell(i, j).value = value
wb.save(self.filename)
Do_Excel('test222.xlsx').write(1,1,'sdcds')
Do_Excel('test222.xlsx').write(1,2,'change')
Do_Excel('test222.xlsx').write(3,2,'pass')
other
b = os.path.normpath("C:/haicoder\haicoder.txt")print(b)# 按行读取for i, v in df.iterrows():if v["标注人"]=="苏雅琪":# 追加数据# df.loc[df.shape[0]] = []# # 获取当前行数# print(df.shape[0])# # print(i,v)# 根据 索引标签获取值print(df.loc[i])