向Excel表中写入数据
def WriteExcel(data):
# 一维数组长度表示行数, 二维数组表示行和列
wb = None
sh = None
Path = None
Title = [u'3次', u'2次', u'1次', u'0次']
AllPath = getFilePath()
if AllPath != -1:
# 判断文件目录是否存在
if not os.path.exists(AllPath):
os.makedirs(AllPath)
if not os.path.exists(AllPath + r"\coefficient.xlsx"):
# 创建一个表
wb = Workbook()
# 创建Excel表中的Sheet
Coefficient = wb.create_sheet(index=0, title="Coefficient")
Coefficient.append(Title)
wb.save(AllPath + r"\coefficient.xlsx")
CheckExcelIsOpen(AllPath, "coefficient.xlsx")
wb = load_workbook(AllPath + r"\coefficient.xlsx")
# 获取Excel表格中的所有sheet
sheets = wb.worksheets
SheetFlag = []
for i in range(len(sheets)):
strV = ''
valueIndex = str(sheets[i])
for j in range(12, len(valueIndex) - 2):
strV += valueIndex[j]
if strV == "Coefficient":
SheetFlag.append(strV)
if strV == "Sheet":
Sheet = wb["Sheet"]
wb.remove(Sheet)
if len(SheetFlag) != 1:
Original = ["Coefficient"]
strValue = list(set(Original) - set(SheetFlag))
if len(strValue) != 0:
for nameSheet in strValue:
if nameSheet == 'Coefficient':
Coefficient = wb.create_sheet(index=0, title="Coefficient")
Coefficient.append(Title)
SheetResult = wb["Coefficient"]
SheetResult.append(data)
SheetResult.cell(row=SheetResult.max_row, column=2)
wb.save(AllPath + r"\coefficient.xlsx")
读取Excel表中数据
def ReadExcel():
AllPath = getFilePath()
if AllPath != -1:
# 默认可读写的
wb = load_workbook(AllPath + r"\coefficient.xlsx", read_only=True, data_only=True)
for sheetName in wb.sheetnames:
sheet = wb[sheetName]
print(f'读取数据为:{[sheet.cell(row=i, column=3).value for i in range(10, 40)]}')