找回密码
 立即注册

QQ登录

只需一步,快速开始

zheyuankeji

注册会员

9

主题

15

帖子

105

积分

注册会员

积分
105
zheyuankeji
注册会员   /  发表于:2019-6-3 16:52  /   查看:3380  /  回复:3
数据:[{"NBGSJ":"2018-06-01","ZCZBH":"201805101546","GJRQ":"2018-05-10","BUSINESSID":"1d17380238f849f3aae8815cb03e7a80","JZMJ":1000,"BGQSSJ":"2018-05-01","ZCLBMC":"房屋建(构)筑物","ZZPH":"201805101546","ZCCBH":"201805101546","ZLF":1000,"ZCMC":"测试资产201805101546","ZLKSSJ":"2018-06","YTMC":"办公租赁","PROCINSID":"10e628ba8d2e4a059cb0f75169fbf0c1","CZFMC":"应付一次性供应商","LOGSYS":"PO3CLNT800","ZCYZ":100,"ZLZZSJ":"2018-12","ZLYT":"9D79E2BD9C524A19AAC676BFD77B6E7A","BGR":"724c9979a2f24fa6b801db84010bd009","BGZZSJ":"2018-11-30","CZF":"00ZZ140004","EJDWDM":"30200001","GGXH":"201805101546","ZLQX":"183","ZCLB":"EDBE112B113D4E539785F11726FFC364","ND":2018,"BGYY":"组织安排","ZRMJ":100},{"NBGSJ":"2018-06-01","ZCZBH":"201805101549","BUSINESSID":"b2f7579c0c214d53ae1087071de348bf","BGQSSJ":"2018-05-01","ZCLBMC":"车辆","ZZPH":"201805101549","ZCCBH":"201805101549","ZLF":1000,"ZCMC":"测试资产201805101549","ZLKSSJ":"2018-05","YTMC":"生产租赁","PROCINSID":"13f916e72e0a4bf488be0ed588b41eb5","CZFMC":"陈涛1-江汉","LOGSYS":"PO3CLNT800","ZCYZ":10000,"ZLZZSJ":"2018-11","ZLYT":"B0A27A3EBA4B4BE8B077F5D7FBFC0B00","BGR":"724c9979a2f24fa6b801db84010bd009","BGZZSJ":"2018-10-31","CZF":"E01136717","EJDWDM":"30200001","GGXH":"201805101549","ZLQX":"184","ZCLB":"AAFB97135A3143299055CF80E47A205B","ND":2018,"BGYY":"组织安排"}]

设计器模版js:var myTable = {"version":"12.0.0","tabStripVisible":false,"newTabVisible":false,"sheetCount":2,"sheets":{"Sheet1":{"name":"Sheet1","columnCount":28,"activeRow":14,"activeCol":11,"theme":"Office","data":{"dataTable":{"0":{"0":{"value":"序号","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"1":{"value":"合同名称","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"2":{"value":"资产编号","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"3":{"value":"资产名称","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"4":{"value":"资产原值","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"5":{"value":"规格型号","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"6":{"value":"产权证号/执照牌号","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2},"wordWrap":true}},"7":{"value":" 租出面积(平方米) ","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2},"wordWrap":true}},"8":{"value":"地理位置","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 13.3333px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"9":{"value":"租赁用途","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"10":{"value":"出租方","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"11":{"value":"租赁时间","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"12":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"13":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"14":{"value":"建筑面积(平方米)","style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"15":{"value":"租赁用途代码","style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"16":{"value":"出租方代码","style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"17":{"value":"保管起始时间","style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"18":{"value":"保管终止时间","style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"19":{"value":"变更原因","style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"20":{"value":"拟变更时间","style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"21":{"value":"资产次编号","style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"22":{"value":"源系统","style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"23":{"value":"年度","style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"24":{"value":"二级单位代码","style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"25":{"value":"保管人","style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"26":{"value":"流程业务id","style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"27":{"value":"流程实例id","style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}}},"1":{"0":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"1":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"2":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"3":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"4":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"5":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"6":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2},"wordWrap":true}},"7":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2},"wordWrap":true}},"8":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 13.3333px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"9":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"10":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"11":{"value":"租赁开始日期","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"12":{"value":"租赁终止日期","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"13":{"value":"租赁期限","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"14":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"15":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"16":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"17":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"18":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"19":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"20":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"21":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"22":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"23":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"24":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"25":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"26":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}},"27":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px \"Agency FB\"","wordWrap":true}}},"2":{"14":{"style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"15":{"value":"ZLQX2","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"16":{"value":"ZLQX3","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"17":{"value":"ZLQX4","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"18":{"value":"ZLQX5","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"19":{"value":"ZLQX6","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"20":{"value":"ZLQX7","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"21":{"value":"ZLQX8","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"22":{"value":"ZLQX9","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"23":{"value":"ZLQX10","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"24":{"value":"ZLQX11","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"25":{"value":"ZLQX12","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"26":{"value":"ZLQX13","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"27":{"value":"ZLQX14","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}}},"8":{"13":{"style":{"hAlign":1,"vAlign":1,"font":"12px Calibri"}}}},"rowDataArray":[{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}}],"columnDataArray":[{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}}],"defaultDataNode":{"style":{"themeFont":"Body"}}},"rowHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"colHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"rows":[{"size":15},{"size":15},{"size":21}],"columns":[{},{},{},{"size":70},{"size":68},{},{"size":76},{"size":82},{},{},{},{"size":86},{"size":82},{"size":67},{"size":71,"visible":false},{"size":84,"visible":false},{"size":68,"visible":false},{"size":82,"visible":false},{"size":80,"visible":false},{"visible":false},{"size":75,"visible":false},{"size":71,"visible":false},{"visible":false},{"visible":false},{"size":84,"visible":false},{"visible":false},{"size":66,"visible":false},{"size":78,"visible":false}],"colHeaderRowInfos":[{}],"spans":[{"row":0,"rowCount":2,"col":0,"colCount":1},{"row":0,"rowCount":2,"col":1,"colCount":1},{"row":0,"rowCount":2,"col":2,"colCount":1},{"row":0,"rowCount":2,"col":3,"colCount":1},{"row":0,"rowCount":2,"col":4,"colCount":1},{"row":0,"rowCount":2,"col":5,"colCount":1},{"row":0,"rowCount":2,"col":6,"colCount":1},{"row":0,"rowCount":2,"col":7,"colCount":1},{"row":0,"rowCount":2,"col":8,"colCount":1},{"row":0,"rowCount":2,"col":9,"colCount":1},{"row":0,"rowCount":2,"col":10,"colCount":1},{"row":0,"rowCount":1,"col":11,"colCount":3},{"row":0,"rowCount":2,"col":14,"colCount":1},{"row":0,"rowCount":2,"col":15,"colCount":1},{"row":0,"rowCount":2,"col":16,"colCount":1},{"row":0,"rowCount":2,"col":17,"colCount":1},{"row":0,"rowCount":2,"col":18,"colCount":1},{"row":0,"rowCount":2,"col":27,"colCount":1},{"row":0,"rowCount":2,"col":19,"colCount":1},{"row":0,"rowCount":2,"col":20,"colCount":1},{"row":0,"rowCount":2,"col":21,"colCount":1},{"row":0,"rowCount":2,"col":22,"colCount":1},{"row":0,"rowCount":2,"col":23,"colCount":1},{"row":0,"rowCount":2,"col":24,"colCount":1},{"row":0,"rowCount":2,"col":25,"colCount":1},{"row":0,"rowCount":2,"col":26,"colCount":1}],"selections":{"0":{"row":14,"rowCount":1,"col":11,"colCount":1},"length":1},"tables":[{"name":"Table1","row":2,"col":0,"rowCount":1,"colCount":28,"bandRows":false,"style":{"buildInName":"Medium2"},"autoGenerateColumns":false,"bindingPath":"field-0","rowFilter":{"range":{"row":3,"rowCount":0,"col":0,"colCount":28},"typeName":"HideRowFilter","dialogVisibleInfo":{},"filterButtonVisibleInfo":{"0":false,"1":false,"2":false,"3":false,"4":false,"5":false,"6":false,"7":false,"8":false,"9":false,"10":false,"11":false,"12":false,"13":false,"14":true,"15":true,"16":true,"17":true,"18":true,"19":true,"20":true,"21":true,"22":true,"23":true,"24":true,"25":true,"26":true,"27":true},"showFilterButton":true},"columns":[{"id":1,"name":"XH","dataField":"XH"},{"id":2,"name":"HTMC","dataField":"HTMC"},{"id":3,"name":"ZCZBH","dataField":"ZCZBH"},{"id":4,"name":"ZCMC","dataField":"ZCMC"},{"id":5,"name":"ZCYZ","dataField":"ZCYZ"},{"id":6,"name":"GGXH","dataField":"GGXH"},{"id":7,"name":"ZZPH","dataField":"ZZPH"},{"id":8,"name":"ZRMJ","dataField":"ZRMJ"},{"id":9,"name":"DLWZ","dataField":"DLWZ"},{"id":10,"name":"YTMC","dataField":"YTMC"},{"id":11,"name":"CZFMC","dataField":"CZFMC"},{"id":12,"name":"ZLKSSJ","dataField":"ZLKSSJ"},{"id":13,"name":"ZLZZSJ","dataField":"ZLZZSJ"},{"id":14,"name":"ZLQX","dataField":"ZLQX"},{"id":15,"name":"JZMJ","dataField":"JZMJ"},{"id":16,"name":"ZLYT","dataField":"ZLYT"},{"id":17,"name":"CZF","dataField":"CZF"},{"id":18,"name":"BGQSSJ","dataField":"BGQSSJ"},{"id":19,"name":"BGZZSJ","dataField":"BGZZSJ"},{"id":20,"name":"BGYY","dataField":"BGYY"},{"id":21,"name":"NBGSJ","dataField":"NBGSJ"},{"id":22,"name":"ZCCBH","dataField":"ZCCBH"},{"id":23,"name":"LOGSYS","dataField":"LOGSYS"},{"id":24,"name":"ND","dataField":"ND"},{"id":25,"name":"EJDWDM","dataField":"EJDWDM"},{"id":26,"name":"BGR","dataField":"BGR"},{"id":27,"name":"BUSINESSID","dataField":"BUSINESSID"},{"id":28,"name":"PROCINSID","dataField":"PROCINSID"}]}],"gridline":{"showHorizontalGridline":false,"showVerticalGridline":false},"index":0},"Sheet2":{"name":"Sheet2","theme":"Office","data":{"dataTable":{}},"rowHeaderData":{},"colHeaderData":{},"selections":{"0":{"row":0,"rowCount":1,"col":0,"colCount":1},"length":1},"index":1}},"namedStyles":[{"name":"Calculation","backColor":"#F2F2F2","foreColor":"#FCA957","border":"thin solid black","font":"bold 13px Arial","borderTop":{"style":1},"borderBottom":{"style":1},"borderLeft":{"style":1},"borderRight":{"style":1}}],"designerBindingPathSchema":{"$schema":"http://json-schema.org/draft-04/schema#","properties":{"field-0":{"dataFieldType":"table","type":"array","items":{"type":"object","properties":{"XH":{"type":"string"},"HTMC":{"type":"string"},"ZCZBH":{"type":"string"},"ZCMC":{"type":"string"},"ZCYZ":{"type":"string"},"GGXH":{"type":"string"},"ZZPH":{"type":"string"},"ZRMJ":{"type":"string"},"DLWZ":{"type":"string"},"YTMC":{"type":"string"},"CZFMC":{"type":"string"},"ZLKSSJ":{"type":"string"},"ZLZZSJ":{"type":"string"},"ZLQX":{"type":"string"},"JZMJ":{"type":"string"},"ZLYT":{"type":"string"},"CZF":{"type":"string"},"BGQSSJ":{"type":"string"},"BGZZSJ":{"type":"string"},"BGYY":{"type":"string"},"NBGSJ":{"type":"string"},"ZCCBH":{"type":"string"},"LOGSYS":{"type":"string"},"ND":{"type":"string"},"EJDWDM":{"type":"string"},"BGR":{"type":"string"},"BUSINESSID":{"type":"string"},"PROCINSID":{"type":"string"}}}}},"type":"object"}};

3 个回复

倒序浏览
KevinChen讲师达人认证 悬赏达人认证 SpreadJS 开发认证
论坛元老   /  发表于:2019-6-4 10:09:18
沙发
您好,参考代码如下:

  1. var myTable = {"version":"12.0.0","tabStripVisible":false,"newTabVisible":false,"sheetCount":2,"sheets":{"Sheet1":{"name":"Sheet1","columnCount":28,"activeRow":14,"activeCol":11,"theme":"Office","data":{"dataTable":{"0":{"0":{"value":"序号","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"1":{"value":"合同名称","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"2":{"value":"资产编号","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"3":{"value":"资产名称","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"4":{"value":"资产原值","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"5":{"value":"规格型号","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"6":{"value":"产权证号/执照牌号","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2},"wordWrap":true}},"7":{"value":" 租出面积(平方米) ","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2},"wordWrap":true}},"8":{"value":"地理位置","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 13.3333px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"9":{"value":"租赁用途","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"10":{"value":"出租方","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"11":{"value":"租赁时间","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"12":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"13":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"14":{"value":"建筑面积(平方米)","style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"15":{"value":"租赁用途代码","style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"16":{"value":"出租方代码","style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"17":{"value":"保管起始时间","style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"18":{"value":"保管终止时间","style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"19":{"value":"变更原因","style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"20":{"value":"拟变更时间","style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"21":{"value":"资产次编号","style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"22":{"value":"源系统","style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"23":{"value":"年度","style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"24":{"value":"二级单位代码","style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"25":{"value":"保管人","style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"26":{"value":"流程业务id","style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"27":{"value":"流程实例id","style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}}},"1":{"0":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"1":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"2":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"3":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"4":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"5":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"6":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2},"wordWrap":true}},"7":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2},"wordWrap":true}},"8":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 13.3333px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"9":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"10":{"style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"11":{"value":"租赁开始日期","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"12":{"value":"租赁终止日期","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"13":{"value":"租赁期限","style":{"backColor":"rgb(255, 255, 255)","hAlign":1,"vAlign":1,"font":"bold 12px 等线","borderLeft":{"color":"rgb(0, 0, 0)","style":2},"borderTop":{"color":"rgb(0, 0, 0)","style":2},"borderRight":{"color":"rgb(0, 0, 0)","style":2},"borderBottom":{"color":"rgb(0, 0, 0)","style":2}}},"14":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"15":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"16":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"17":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"18":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"19":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"20":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"21":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"22":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"23":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"24":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"25":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"26":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}},"27":{"style":{"hAlign":1,"vAlign":1,"font":"bold 12px "Agency FB"","wordWrap":true}}},"2":{"14":{"style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"15":{"value":"ZLQX2","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"16":{"value":"ZLQX3","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"17":{"value":"ZLQX4","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"18":{"value":"ZLQX5","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"19":{"value":"ZLQX6","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"20":{"value":"ZLQX7","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"21":{"value":"ZLQX8","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"22":{"value":"ZLQX9","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"23":{"value":"ZLQX10","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"24":{"value":"ZLQX11","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"25":{"value":"ZLQX12","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"26":{"value":"ZLQX13","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}},"27":{"value":"ZLQX14","style":{"backColor":"Accent 1","foreColor":"white","hAlign":1,"vAlign":1,"font":"bold 14.6667px calibri","borderTop":{"color":"Accent 1 20","style":1},"borderRight":{"color":"Accent 1 20","style":1},"borderBottom":{"color":"Accent 1 20","style":1},"imeMode":1}}},"8":{"13":{"style":{"hAlign":1,"vAlign":1,"font":"12px Calibri"}}}},"rowDataArray":[{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}}],"columnDataArray":[{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}},{"style":{"hAlign":1,"vAlign":1}}],"defaultDataNode":{"style":{"themeFont":"Body"}}},"rowHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"colHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"rows":[{"size":15},{"size":15},{"size":21}],"columns":[{},{},{},{"size":70},{"size":68},{},{"size":76},{"size":82},{},{},{},{"size":86},{"size":82},{"size":67},{"size":71,"visible":false},{"size":84,"visible":false},{"size":68,"visible":false},{"size":82,"visible":false},{"size":80,"visible":false},{"visible":false},{"size":75,"visible":false},{"size":71,"visible":false},{"visible":false},{"visible":false},{"size":84,"visible":false},{"visible":false},{"size":66,"visible":false},{"size":78,"visible":false}],"colHeaderRowInfos":[{}],"spans":[{"row":0,"rowCount":2,"col":0,"colCount":1},{"row":0,"rowCount":2,"col":1,"colCount":1},{"row":0,"rowCount":2,"col":2,"colCount":1},{"row":0,"rowCount":2,"col":3,"colCount":1},{"row":0,"rowCount":2,"col":4,"colCount":1},{"row":0,"rowCount":2,"col":5,"colCount":1},{"row":0,"rowCount":2,"col":6,"colCount":1},{"row":0,"rowCount":2,"col":7,"colCount":1},{"row":0,"rowCount":2,"col":8,"colCount":1},{"row":0,"rowCount":2,"col":9,"colCount":1},{"row":0,"rowCount":2,"col":10,"colCount":1},{"row":0,"rowCount":1,"col":11,"colCount":3},{"row":0,"rowCount":2,"col":14,"colCount":1},{"row":0,"rowCount":2,"col":15,"colCount":1},{"row":0,"rowCount":2,"col":16,"colCount":1},{"row":0,"rowCount":2,"col":17,"colCount":1},{"row":0,"rowCount":2,"col":18,"colCount":1},{"row":0,"rowCount":2,"col":27,"colCount":1},{"row":0,"rowCount":2,"col":19,"colCount":1},{"row":0,"rowCount":2,"col":20,"colCount":1},{"row":0,"rowCount":2,"col":21,"colCount":1},{"row":0,"rowCount":2,"col":22,"colCount":1},{"row":0,"rowCount":2,"col":23,"colCount":1},{"row":0,"rowCount":2,"col":24,"colCount":1},{"row":0,"rowCount":2,"col":25,"colCount":1},{"row":0,"rowCount":2,"col":26,"colCount":1}],"selections":{"0":{"row":14,"rowCount":1,"col":11,"colCount":1},"length":1},"tables":[{"name":"Table1","row":2,"col":0,"rowCount":1,"colCount":28,"bandRows":false,"style":{"buildInName":"Medium2"},"autoGenerateColumns":false,"bindingPath":"field-0","rowFilter":{"range":{"row":3,"rowCount":0,"col":0,"colCount":28},"typeName":"HideRowFilter","dialogVisibleInfo":{},"filterButtonVisibleInfo":{"0":false,"1":false,"2":false,"3":false,"4":false,"5":false,"6":false,"7":false,"8":false,"9":false,"10":false,"11":false,"12":false,"13":false,"14":true,"15":true,"16":true,"17":true,"18":true,"19":true,"20":true,"21":true,"22":true,"23":true,"24":true,"25":true,"26":true,"27":true},"showFilterButton":true},"columns":[{"id":1,"name":"XH","dataField":"XH"},{"id":2,"name":"HTMC","dataField":"HTMC"},{"id":3,"name":"ZCZBH","dataField":"ZCZBH"},{"id":4,"name":"ZCMC","dataField":"ZCMC"},{"id":5,"name":"ZCYZ","dataField":"ZCYZ"},{"id":6,"name":"GGXH","dataField":"GGXH"},{"id":7,"name":"ZZPH","dataField":"ZZPH"},{"id":8,"name":"ZRMJ","dataField":"ZRMJ"},{"id":9,"name":"DLWZ","dataField":"DLWZ"},{"id":10,"name":"YTMC","dataField":"YTMC"},{"id":11,"name":"CZFMC","dataField":"CZFMC"},{"id":12,"name":"ZLKSSJ","dataField":"ZLKSSJ"},{"id":13,"name":"ZLZZSJ","dataField":"ZLZZSJ"},{"id":14,"name":"ZLQX","dataField":"ZLQX"},{"id":15,"name":"JZMJ","dataField":"JZMJ"},{"id":16,"name":"ZLYT","dataField":"ZLYT"},{"id":17,"name":"CZF","dataField":"CZF"},{"id":18,"name":"BGQSSJ","dataField":"BGQSSJ"},{"id":19,"name":"BGZZSJ","dataField":"BGZZSJ"},{"id":20,"name":"BGYY","dataField":"BGYY"},{"id":21,"name":"NBGSJ","dataField":"NBGSJ"},{"id":22,"name":"ZCCBH","dataField":"ZCCBH"},{"id":23,"name":"LOGSYS","dataField":"LOGSYS"},{"id":24,"name":"ND","dataField":"ND"},{"id":25,"name":"EJDWDM","dataField":"EJDWDM"},{"id":26,"name":"BGR","dataField":"BGR"},{"id":27,"name":"BUSINESSID","dataField":"BUSINESSID"},{"id":28,"name":"PROCINSID","dataField":"PROCINSID"}]}],"gridline":{"showHorizontalGridline":false,"showVerticalGridline":false},"index":0},"Sheet2":{"name":"Sheet2","theme":"Office","data":{"dataTable":{}},"rowHeaderData":{},"colHeaderData":{},"selections":{"0":{"row":0,"rowCount":1,"col":0,"colCount":1},"length":1},"index":1}},"namedStyles":[{"name":"Calculation","backColor":"#F2F2F2","foreColor":"#FCA957","border":"thin solid black","font":"bold 13px Arial","borderTop":{"style":1},"borderBottom":{"style":1},"borderLeft":{"style":1},"borderRight":{"style":1}}],"designerBindingPathSchema":{"$schema":"http://json-schema.org/draft-04/schema#","properties":{"field-0":{"dataFieldType":"table","type":"array","items":{"type":"object","properties":{"XH":{"type":"string"},"HTMC":{"type":"string"},"ZCZBH":{"type":"string"},"ZCMC":{"type":"string"},"ZCYZ":{"type":"string"},"GGXH":{"type":"string"},"ZZPH":{"type":"string"},"ZRMJ":{"type":"string"},"DLWZ":{"type":"string"},"YTMC":{"type":"string"},"CZFMC":{"type":"string"},"ZLKSSJ":{"type":"string"},"ZLZZSJ":{"type":"string"},"ZLQX":{"type":"string"},"JZMJ":{"type":"string"},"ZLYT":{"type":"string"},"CZF":{"type":"string"},"BGQSSJ":{"type":"string"},"BGZZSJ":{"type":"string"},"BGYY":{"type":"string"},"NBGSJ":{"type":"string"},"ZCCBH":{"type":"string"},"LOGSYS":{"type":"string"},"ND":{"type":"string"},"EJDWDM":{"type":"string"},"BGR":{"type":"string"},"BUSINESSID":{"type":"string"},"PROCINSID":{"type":"string"}}}}},"type":"object"}};

  2. var dataArray = [{"NBGSJ":"2018-06-01","ZCZBH":"201805101546","GJRQ":"2018-05-10","BUSINESSID":"1d17380238f849f3aae8815cb03e7a80","JZMJ":1000,"BGQSSJ":"2018-05-01","ZCLBMC":"房屋建(构)筑物","ZZPH":"201805101546","ZCCBH":"201805101546","ZLF":1000,"ZCMC":"测试资产201805101546","ZLKSSJ":"2018-06","YTMC":"办公租赁","PROCINSID":"10e628ba8d2e4a059cb0f75169fbf0c1","CZFMC":"应付一次性供应商","LOGSYS":"PO3CLNT800","ZCYZ":100,"ZLZZSJ":"2018-12","ZLYT":"9D79E2BD9C524A19AAC676BFD77B6E7A","BGR":"724c9979a2f24fa6b801db84010bd009","BGZZSJ":"2018-11-30","CZF":"00ZZ140004","EJDWDM":"30200001","GGXH":"201805101546","ZLQX":"183","ZCLB":"EDBE112B113D4E539785F11726FFC364","ND":2018,"BGYY":"组织安排","ZRMJ":100},{"NBGSJ":"2018-06-01","ZCZBH":"201805101549","BUSINESSID":"b2f7579c0c214d53ae1087071de348bf","BGQSSJ":"2018-05-01","ZCLBMC":"车辆","ZZPH":"201805101549","ZCCBH":"201805101549","ZLF":1000,"ZCMC":"测试资产201805101549","ZLKSSJ":"2018-05","YTMC":"生产租赁","PROCINSID":"13f916e72e0a4bf488be0ed588b41eb5","CZFMC":"陈涛1-江汉","LOGSYS":"PO3CLNT800","ZCYZ":10000,"ZLZZSJ":"2018-11","ZLYT":"B0A27A3EBA4B4BE8B077F5D7FBFC0B00","BGR":"724c9979a2f24fa6b801db84010bd009","BGZZSJ":"2018-10-31","CZF":"E01136717","EJDWDM":"30200001","GGXH":"201805101549","ZLQX":"184","ZCLB":"AAFB97135A3143299055CF80E47A205B","ND":2018,"BGYY":"组织安排"}];
  3. // 设置数据源中,表格数据路径
  4. var data = {myData: dataArray};
  5. var spread = GC.Spread.Sheets.findControl("ss");
  6. spread.fromJSON(myTable);
  7. // 创建cellbindingsource带绑定路径的数据源实例
  8. var dataSource = new GC.Spread.Sheets.Bindings.CellBindingSource(data)
  9. var sheet = spread.getActiveSheet();
  10. // 获取表
  11. var table = sheet.tables.all()[0];
  12. // 设置表格的绑定路径
  13. table.bindingPath("myData");
  14. // 设置数据源
  15. sheet.setDataSource(dataSource);
  16. // 可以把表头隐藏
  17. sheet.setRowVisible(2,false);
复制代码


运行效果如图:

image.png247832030.png
回复 使用道具 举报
zheyuankeji
注册会员   /  发表于:2019-6-5 17:05:26
板凳
KevinChen 发表于 2019-6-4 10:09
您好,参考代码如下:

myTable复制成ssjson文件,导入设计器没反应,怎么回事
回复 使用道具 举报
KevinChen讲师达人认证 悬赏达人认证 SpreadJS 开发认证
论坛元老   /  发表于:2019-6-6 08:56:01
地板
您是怎么操作的?要导入设计器,需要完整的整个workbook的ssjson,单独导出table的json设计器无法识别。
回复 使用道具 举报
您需要登录后才可以回帖 登录 | 立即注册
返回顶部