python 导表---xls笔记

idx:

[角色.xls]
角色属性:role
美术:art
动作:action

cfg = configparser.ConfigParser()

cfg.read("idx","utf-8")

for i in cfg.sections():
        for j in cfg[i]:
            xls_tasks[cfg[i][j]].append([i, j])

i : 角色.xls

j : 角色属性

cfg[i][j] :role

解析json：

    with open(os.path.join("tmp", ".org", k), encoding="utf-8") as f:

            json_outputs[k] = json.load(f)#解析json

得 {'asset':'R001','anger':100}

另 用 with open(os.path.join("tmp", ".org", k), encoding="utf-8") as f:

               f.write("ssasas")

如果文件不存在，则自动创建

 #functools.partial用法
        # def add(a, b):
        #     return a + b
        # add(4, 2)
        # 6
        # plus3 = functools.partial(add, 3)
        # plus5 = functools.partial(add, 5)
        # plus3(4)
        # 7

 #takewhile(lambda x: x < 5, [1, 3, 6, 7, 1])
    #当函数返回True时，收集元素到循环器。一旦函数返回False，则停止。1, 3
    #isinstance(x, str)   
    #判断x是否是str类或者object是变量

#os.path.getmtime(path) 文件最后修改时间 exists 判断文件是否存在，ture
    #json_outputs[k].extend(parse(xls, sheet))添加数据类型

     json_outputs[k].extend(parse(xls, sheet))#extend 使[a,b] 中的元素展开append进去

--------------------------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------

------------------------------------------------------------

--------------------------------------------

python导表代码如下：

#!/usr/bin/env python3 # xls import collections import configparser import functools import itertools import json import logging import os import pprint import re import shelve import sys import time import traceback import xlrd class EvalCache(dict): #重写字典类 相当于“2+3+5”的value可eval（value）计算 def __missing__(self, k): code = compile(k, k, "eval") self[k] = code return code _eval_cache = EvalCache() _eval = eval def eval(source, globals=None, locals=None): """patch built-in function `eval`, this new eval is faster""" return _eval(_eval_cache[source], globals, locals) class Default(dict): def __missing__(self, key): return key eval_env = Default() #functools.partial用法 # def add(a, b): # return a + b # add(4, 2) # 6 # plus3 = functools.partial(add, 3) # plus5 = functools.partial(add, 5) # plus3(4) # 7 dump_sorted = functools.partial(json.dumps, ensure_ascii=False, separators = (",", ": "), sort_keys=True, indent=4) dump_raw = functools.partial(js