python实现vlookup功能(代码存在很大漏洞请大神们予以指点,感激不尽)
在这里插入代码片@TOCimport xlwings as xw#工作簿1path1 = r’C:\Users\Administrator\Desktop\主表.xlsx’app1 = xw.App()books1 = app1.books.open(path1)sheet1 = books1.sheets(‘Sheet1’)data1 = sheet1.range(‘a2:n741163’).valuebooks1.save(path1)books1.close()app1.quit(
原创
2020-12-23 09:58:03 ·
628 阅读 ·
0 评论