excel转换为TXT文本

#_*_ coding:utf-8 _*_
#author:yr

import xlrd

data = xlrd.open_workbook(r"C:\Users\yangr\Desktop\DuerOS远场设备对外测试统计表v3.0.xlsx")
st = data.sheets()[0] #sheets:纸,一张,被单
rows = st.nrows #行数
# with open (r"C:\Users\yangr\Desktop\exceltotxt","a+") as f:
for i in range(rows+1):
print(st.row_values(i))

posted @ 2018-12-19 11:20  小小海贼闯天涯  阅读(268)  评论(0编辑  收藏  举报