1.导入第三方库openpyxl
from openpyxl import load_workbook
2.加载指定目录excel文件
wb = load_workbook('问题分类.xlsx')
3.读取指定sheet
ws = wb['Sheet1']
4.读取第一列的内容
# 一级分类
scene_classify_list1 = []
for i, row in enumerate(ws.iter_rows()):
for j, cell in enumerate(row):
if j == 0 and cell.value is not None:
scene_classify_list1.append(cell.value)
break
#打印日志,转成json字符串
print( json.dumps(scene_classify_list1, ensure_ascii=False))