import xlrd
import os
import sys
def getListFiles(path):
ret = []
for root, dirs, files in os.walk(path):
for filespath in files:
if filespath.endswith(".xls"):
# ret.append(filespath)
ret.append(os.path.join(root + '\\'+filespath))
elif filespath.endswith(".xlsx"):
# ret.append(filespath)
ret.append(os.path.join(root+'\\'+filespath))
return ret
def strs(row):
"""
:返回一行数据
"""
try:
values = "";
for i in range(len(row)):
if i == len(row) - 1:
values = values + str(row[i])
else:
#使用“,”逗号作为分隔符
values = values + str(row[i]) + ","
return values
except:
raise
def xls_txt(xls_name,txt_name):
"""
:excel文件转换为txt文件
:param xls_name excel 文件名称
:param txt_name txt 文件名称
"""
data = xlrd.open_workbook(xls_name)
sqlfile = open(txt_name, "a",encoding='utf8')
table = data.sheets()[0] # 表头
nrows = table.nrows # 行数
#如果不需跳过表头,则将下一行中1改为0
for ronum in range(1, nrows):
row = table.row_values(ronum)
values = strs(row) # 条用函数,将行数据拼接成字符串