# python3
#-*- coding:utf-8 _*-import xlrd# 写文件
def writendata(data):name='writedemo.txt'w = open(name, 'a', encoding='utf-8')w.write(data + '\n')w.close()print('写入成功')def main2():name='副本.xlsx'ncint=input('输入需要获取那一列的数据')inc=int(ncint)print(inc)sheet_index=0workbook=xlrd.open_workbook(name)sheet=workbook.sheet_by_index(sheet_index)for s in range(0, sheet.nrows): # 获取行#print('*******行******',s)va = sheet.cell(s, inc).valuewritendata(va)print(va)
main2()
自行安装xlrd库