def read_excle():
data = xd.open_workbook('/Users/apple/Desktop/test.xlsx')
sheet = data.sheet_by_name('Sheet1')
for i in range(sheet.ncols):
for c in range(sheet.nrows):
doc = sheet.cell_value(c,i)
open_file_write(doc = doc,i = i)
def open_file_write(doc,i):
road = '/Users/apple/Desktop/TextMining/allreadfile/'+str(i)+'.txt'
f = open(road,'w')
f.write(doc)
f.close()
read_excle()