{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Json1","array~Json1","dic#{}~Json1","Json2#{}","装备#obj~Json2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Json1","index":0,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["主键","字典测试","这一行可以用作注释"]
["*key","value1#{}","value2#[]","value3#obj","value4"]
["key1","a:1|b:2","1|2|3|4","攻击:100",-2]
["key2","字典","你好|我很好|你呢","攻击:100|防御:100",-1]
["key3","名称:字典",1,"攻击:100|防御:100|闪避:100",0]
["key4",null,null,"攻击:100|防御:100|闪避",1]

{"sheet":"array~Json1","index":1,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["列表测试，以列表形式输出到json1的array项",null,null,null,"公式计算","公式计算","数值"]
["~","*key","value1","value2#int","value3#float#2","value4#float","value5#float","value6#bool"]
["key1","array1","2018-09-16",1,10,10,10,0]
["key2","array2","2018-09-17",{"$f":"D3+0.35","v":1.35},{"$f":"E3*0.85","v":8.5},{"$f":"F3*0.85","v":8.5},8.5,false]
["key3","array3","2018-09-18",{"$f":"D4+0.35","v":1.7000000000000002},{"$f":"E4*0.85","v":7.2249999999999996},7.2249999999999996,7.2249999999999996,true]
["key1","array4","2018-09-19",2.0500000000000003,6.1412499999999994,6.1412499999999994,6.1412500000000003,1]
["key2","array5","2018-09-20",2.4000000000000004,5.2200624999999992,5.2200624999999992,5.2200625,2]
["key3","array6","2018-09-21",2.7500000000000004,4.4370531249999994,4.4370531249999994,4.4370531250000003,"shijie"]
["key1","array7","2018-09-22",3.1000000000000005,3.7714951562499994,3.7714951562499994,3.7714951559999998,"世界"]
["key2","array8","2018-09-23",3.4500000000000006,3.2057708828124993,3.2057708828124993,3.205770883,"2018-09-23"]
["key3","array9","2018-09-24",3.8000000000000007,2.7249052503906244,2.7249052503906244,2.7249052499999999,"1,2,3"]

{"sheet":"dic#{}~Json1","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["字典测试，以字典的形式输出到json1的dic项"]
["~主表","*key","value"]
["key1","dic1","value1"]
["key2","dic2","value2"]
["key3","dic3","value3"]
["key1","dic4","value4"]
["key2","dic5","value5"]
["key3","dic6","value6"]
["key1","dic7","value7"]
["key2","dic8","value8"]
["key3","dic9","value9"]

{"sheet":"Json2#{}","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
["key#{}","姓名"]
["key1","张三"]
["key2","李四"]
["key3","王五"]
["key4","赵六"]

{"sheet":"装备#obj~Json2","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"对象测试，生成的json2中的每个人都会有武器副手衣服三件装备，但是没有装备这一属性"]
["~","*name","attribute#{}","buff#[]"]
["key1","武器","攻击:10|防御:5","buff1|buff2"]
["key2","武器","攻击:20","buff3"]
["key3","武器","攻击:15|攻速:10"]
["key3","武器","攻击:15","buff2"]
["key1","副手","攻击:5|攻速:5"]
["key2","副手","防御:5|格挡:5","buff5|buff6|buff7"]
["key3","副手","攻击:10|防御5"]
["key1","衣服","生命:100|防御:10","buff2"]
["key2","衣服","生命:100|防御:11","buff4|buff2"]
["key3","衣服","生命:100|防御:12"]