摘要:
前一篇为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 阅读全文
摘要:
1 from openpyxl import load_workbook 2 # from openpyxl.drawing.text import Paragraph, RegularTextRun 3 from openpyxl.worksheet.hyperlink import Hyperl 阅读全文