{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["新户导入模板","数据字典","Sheet3"],"not_rendered":{"external_links":1,"defined_names":10},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"新户导入模板","index":0,"n_rows":17,"n_cols":28,"rows_kept":17,"flags":["formulas_cached_only"]}
["UserId","户名","地址","用户类型","联系电话","手机号码","口径","用水类别","证件名称","证件号码","email","银行代码","税号","帐号","帐户类型","表身号","水表底度","表册号","抄表周期","立户日期","水表厂家","水表型号","水表用途","装表日期","挂表人员","水表位置","水表通讯卡号","采集编号"]
[null,"张三 ","XX小区X#楼X单元X楼东户",null,"13581178155",{"$nulls":4},"37250119821004XXXX"]
{"$rows_empty":10}
["填报说明："]
["1.用户只需填写户名、地址、联系电话、证件号码。"]
["2.未售房可不填以上信息，但须保留该行地址，方便后期更新。"]
["3.该表信息应与居民用水合同信息顺序保持一致。"]
["4.如有问题请咨询电话8902679。"]

{"sheet":"数据字典","index":1,"n_rows":15,"n_cols":10,"rows_kept":15,"flags":["formulas_cached_only"]}
["用户类型","水表口径","用水类别","证件类型","帐户类型","抄表周期","水表厂家","水表型号","水表类型","水表用途"]
["个人用户",15,"低保居民用水","身份证","现金户","每月抄表","青岛积成",1,"NB","计费表"]
["单位用户",20,"合表居民用水","营业执照","代扣户","单月抄表","济南瑞泉",2,"市电有线","核算表"]
[null,25,"居民用水非居民用户","护照","其他","双月抄表","杭州炬华",3,"机械表"]
[null,40,"居民生活用水","军官证",null,"季初抄表","唐山汇中",4,"LORA"]
[null,50,"高新区原水(0.98)","特困证号码",null,"季中抄表","三川智慧",5,"物联网表"]
[null,80,"非居民生活用水","户口本",null,"季末抄表","浙江天信"]
[null,100,"区水利局农村供水","港澳台身份证",null,"两月抄表","深圳捷先"]
[null,150,"非居民生活用水（D类1）","其他证件",null,"三月抄表","南京迈拓"]
[null,200,"高新区原水（1.04+0.7）","港澳台通行证",null,"四月抄表","临沂水表"]
[null,300,"非居民生活用水（D类1.5）",null,null,"废卡本","开封水表"]
[null,null,"非居民生活用水（D类2）",{"$nulls":3},"宁波水表"]
[null,null,"非居民生活用水（无污水）"]
[null,null,"医疗机构9折用水"]
[null,null,"特种用水"]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}