一、python读取Excel
import xlrd
try:
data = xlrd.open_workbook('source_code/CSI1k.xls')
except:
print("fail to open file")
else:
# 读取第一个sheet
table = data.sheets()[0]
# 获取行数
n = table.nrows
for i in range(n):
# 取第i行第0列的值
code = table.cell(i, 0).value
print(code)