python判断数据和excel中是否相等_请问各位大神，Python能比较两个excel表格中的相同行...

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

import xlrd

import xlsxwriter

# 创建工作簿

def filewriting(file_path,file_name,datas):

workbook = xlsxwriter.Workbook(file_path) # 创建文件

worksheet = workbook.add_worksheet(file_name) # 创建工作表

for i,data in enumerate(datas):

worksheet.write_row(i, 0, data)

workbook.close() # 关闭工作簿

# 读取

def fileload(filename = '待读取.xlsx'):

dataset = []

workbook = xlrd.open_workbook(filename)

table = workbook.sheets()[0] # 获取一个工作表

for row in range(table.nrows): # 获取总行数，遍历获取

dataset.append(table.row_values(row))

return dataset

file1 = fileload('D:\\book1.xlsx')

file2 = fileload('D:\\book2.xlsx')

same, different = [],[]

# 不知道你想怎么保存，默认一文件1位主要的，自己改

for f1,f2 in zip(file1,file2):

if f1 == f2:

same.append(f1)

else:

different.append(f1)

filewriting('D:\\相同的.xlsx','工作表名字',same)

filewriting('D:\\不同的.xlsx','工作表名字',different)