python 读取excel数据

安装库

pipenv install pandas

pipenv install openpyxl

import pandas as pd
df = pd.read_excel('价格维护_2023-04-03 16_24_096085942237272026841.xlsx
   ...: ')
print(df['定价记录号'])
s = ""

for num in data:
   s += '\'%s\',' % num
   print(num)
   print(s)

参考地址：https://cloud.tencent.com/developer/article/1661483