Python xlwings 操作Excel

• 导入 xlwings
• Excel 操作

导入 xlwings

官方文档 https://docs.xlwings.org/en/stable/vba.html
按照图示，安装 xlwings

Excel 操作

import xlwings as xwdef Operation_Excel(path):    app = xw.App(visible=False, add_book=False)    app.display_alerts = False    app.screen_updating = False    wb = app.books.open(path)    try: sht = wb.sheets[0] rng = sht['A1:D2']  # 取出 A1:D2 单元格内的数据 print(rng.value) s = '' for i in range(0, len(rng.value)):  # 循环行     s += ','.join(  filter(lambda x: x != 'None', map(str, rng.value[i]))) + ' '  # 把行数据先转str，然后去除为None的单元格，剩余的用逗号拼接 # list(map(lambda x: print_str(x), rng)) sht.range('E1:H2').clear()  # 清空 E1:H2 sht.range('E1:H2').merge()  # 合并 E1:H2 sht.range('E1').value = s  # 把合并的内容 填写在合并后的单元格内 wb.save() print(s) wb.close() app.quit()    except Exception as e: print(e.args) wb.close() app.quit()file_path = r"..\files\demo.xlsx"  # 文件相对路径# Press the green button in the gutter to run the script.if __name__ == '__main__':    Operation_Excel(file_path)

开发者涨薪指南 48位大咖的思考法则、工作方式、逻辑体系