import xlwings as xw
import pandas as pd
xlsx = r'F:\abc.xlsx'
app = xw.App(visible=True, add_book=False)
wb = app.books.open(xlsx)
sh2 = wb.sheets['Sheet2']
sh3 = wb.sheets['Sheet3']
info2 = sh2.used_range
nrows = info2.last_cell.row
print(nrows)
newsh = wb.sheets.add()
values = sh2.range(1, 1).expand('right').value
newsh.range(1, 1).value = values
values1 = sh3.range(1, 1).expand('down').value
set1 = set(values1)
row = 2
newrow = 2
while row <= nrows :
val = sh2.range(row, 1).expand('right').value
if val is not None and val[0] in set1:
print(val)
newsh.range(newrow, 1).value = val
newrow = newrow + 1
row = row + 1
print(row-1)
wb.save()
wb.close()
app.quit()
xlwings读取行和写入行应用
扫一扫
205
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
