`
elan1986
  • 浏览: 164582 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

python excle 2 txt

阅读更多
#coding:utf-8
from xlrd import open_workbook
import os, sys
reload(sys)
sys.setdefaultencoding("utf-8")
wb = open_workbook('F:/******.xls')
f = open("d:/list.txt", "w")
for s in wb.sheets():
	print 'Sheet: ', s.name
	for row in range(s.nrows):
		values = []
		for col in range(s.ncols):
			temp = s.cell(row, col).value
			if temp != '':
				f.write(str(temp))
			values.append(temp)
		print values
	print 
f.close()
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics