摘要: 前一篇为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 阅读(304) 评论(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 阅读(473) 评论(0) 推荐(0)