xls文件
需要使用 xlrd 读取 excel
import xlrd
workbook = xlrd.open_workbook(self.gold_path)
sheet = workbook.sheets()[0]
node_map = [i.text for i in list(sheet.cell_note_map.values())]
print(node_map)
## ['a' , 'b', 'c', 'd']
xlsx文件
需要使用 openpyxl 读取excel
wb = openpyxl.load_workbook(self.c2_path)
ws = wb.active
node_map = [ws.cell(row=1, column=i).comment.text for i in range(1, ws.max_column + 1)]
print(node_map)
## ['a' , 'b', 'c', 'd']