摘要: 前一篇为python版,此为vba版 1 Sub CreateHyperlinks() 2 Dim wb As Workbook 3 Dim ws As Worksheet 4 Dim newSheet As Worksheet 5 Dim sheetNames() As String 6 Dim 阅读全文
posted @ 2023-07-04 20:51 oceanbkywind 阅读(270) 评论(0) 推荐(0) 编辑
摘要: 1 from openpyxl import load_workbook 2 # from openpyxl.drawing.text import Paragraph, RegularTextRun 3 from openpyxl.worksheet.hyperlink import Hyperl 阅读全文
posted @ 2023-07-04 20:46 oceanbkywind 阅读(395) 评论(0) 推荐(0) 编辑