Python实现Excel改为txt格式

将excel存储的数据改为txt格式的数据集

import xlrd

fileName = "9类情感-筛选语料2.28.xlsx"
fileHandler = xlrd.open_workbook(fileName) 
sheet_name1=u'Sheet1'
page = fileHandler.sheet_by_name(sheet_name1)    
col1 = page.col_values(0) #文本
col2 = page.col_values(1) #标签
 
f2 = open("data2.txt", "w")
for i in range(len(col1)):
    text = col1[i]
    label = str(int(col2[i]))
    data = text+'\t'+label+'\n'
    f2.write(data)