excel转换txt

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) # 条用函数，将行数据拼接成字符串