{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["表格模板","建筑","设备类型","客户","集中器","采集器"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"comments":5,"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":"表格模板","index":0,"n_rows":4,"n_cols":12,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Tips:1.此模板为批量添加设备模板，请勿随意修改表格内的函数公式与格式，以免影响导入功能的实现；"]
["        2.批量添加设备，最多只能添加5000条数据；"]
["        3.标红必填项/必选项的列表请不要空值。"]
["水表电子号（必填）","水表档案号","水表铅封号","设备型号（必选）","客户（必选）","建筑（必选）","安装地址（必填）","集中器编码（必选）","采集器编码","通道号（必选）","测量点号（必填）","备注"]

{"sheet":"建筑","index":1,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["建筑名称","建筑ID","地下层数","地上层数"]
["${building.name}","${building.id}","${building.underFloorNum}","${building.floorNum}"]

{"sheet":"设备类型","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["设备类型","设备ID"]
["${deviceType.manufacturerName}/${deviceType.equipmentType}/${deviceType.model}","${deviceType.id}"]

{"sheet":"客户","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["客户名称","客户ID"]
["${customer.customerName}","${customer.id}"]

{"sheet":"集中器","index":4,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["集中器编码","通道"]
["${concentrator.serialNumber}","${channelNumber.channelName}"]

{"sheet":"采集器","index":5,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["集中器名称","采集器编码"]
["${concentrator.serialNumber}","${collector.collectorNo}"]