Configs/Core/ExcelExportTool.py

# -*- coding: utf-8 -*-
# 这段代码主要的功能是把excel表格转换成utf-8格式的json文件
import os
import sys
import codecs
import xlrd #http://pypi.python.org/pypi/xlrd
import json
import time
import ExcelInfo
import importlib
importlib.reload(sys)

#获取相对路径下的所有文件名
def all_path(dirname):
    result = {}
    for maindir, subdir, file_name_list in os.walk(dirname):
        for filename in file_name_list:
            apath = os.path.join(maindir, filename)
            result[filename]=apath
    return result

if __name__ == '__main__':
    config=json.load(open( 'Config.json','r'))
    paths=all_path(config["srcFolder"])
    for key in paths:
        if key[0]=='~':#忽略打开的Excel文件产生的临时文件
            continue
        pair=key.split('.')
        if len(pair)<=0:
            continue
        if pair[len(pair)-1]=='xlsx' or pair[len(pair)-1]=='xls':
            print('parsing excel:'+paths[key])
            finalJsons = ExcelInfo.ExcelInfo(paths[key],config["headRow"],config["round"],config["ignoreEmpty"]).FinalTable()
            for key in finalJsons:
                outPath=config["destFolder"]+'/'+ key+'.json'
                with open(outPath,'w',encoding='UTF-8') as fileobject:
                    if config["format"]==True:
                        fileobject.write(json.dumps(finalJsons[key],indent=4,ensure_ascii=False))
                    else:
                        fileobject.write(json.dumps(finalJsons[key],ensure_ascii=False))
                    print('exported json  -->  '+outPath)
            print()

    print("All OK")
    exit(0)