python3之读取xlsx列并写入txt文档

# 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=0
    workbook=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).value
        writendata(va)
        print(va)
main2()

自行安装xlrd库