xlwings 链接到 指定sheet 从别的 excel 复制 sheet 到指定 sheet

重点
可以参考 宏录制

  cell = sheet.range('G4')cell.api.Hyperlinks.Add(Anchor=cell.api, Address="", SubAddress="'001-000-023+01'!A1")

 def deal_excel(self):with xw.App(visible=True) as app:wb = app.books.open(self.summary_path, update_links=False)sheet = wb.sheets[0]for pn in self.pn_list:pn_path = os.path.join(cuixiao_data_raw, f'{pn}.xlsx')wb_pn = app.books.open(pn_path, update_links=False)sheet_pn = wb_pn.sheets[0]new_sheet = sheet_pn.copy(after=wb.sheets[0])new_sheet.name = pnfor i in range(4, 99999):if sheet.range(f'G{i}').value:cell = sheet.range(f'G{i}')value = cell.valueprint('value', i, value)cell.api.Hyperlinks.Add(Anchor=cell.api, Address="", SubAddress=f"'{value}'!A1")else:break# cell = sheet.range('G4')# cell.api.Hyperlinks.Add(Anchor=cell.api, Address="", SubAddress="'001-000-023+01'!A1")sheet.name = 'Summary'sheet.range('A1').value = ''sheet.activate()  # 激活指定的工作表sheet.range('A1').select()  # 选择特定的单元格result_path = os.path.join(cuixiao_data_result, f'{today}_result.xlsx')wb.save(result_path)

参考
https://blog.csdn.net/xcntime/article/details/115640772