{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["结算单"],"not_rendered":{"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"结算单","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[1,1,1,3],[1,6,1,7],[2,1,2,3],[2,6,2,7],[3,1,3,3],[3,6,3,7],[5,2,5,3],[5,6,5,7],[6,2,6,3],[6,6,6,7],[7,2,7,3],[7,6,7,7],[8,1,8,2],[8,3,8,4],[8,6,8,7],[9,6,9,7],[17,1,17,7],[18,1,18,7],[19,1,19,7],[20,1,20,4],[21,1,21,2],[21,3,21,4],[22,1,22,2],[22,3,22,4],[23,1,23,2],[23,3,23,4],[24,1,24,2],[24,3,24,4],[25,1,25,2],[25,3,25,4],[26,1,26,2],[26,3,26,4]]}
[null,"公司名称"]
[null,"街道地址",{"$nulls":3},"电话：","电话号码"]
[null,"地址 2",{"$nulls":3},"传真：","传真号码"]
[null,"省/市/自治区，市/县 邮政编码",{"$nulls":3},"电子邮件：","电子邮件地址"]
[null,"结算单"]
[null,"结算编号：","结算编号",null,null,"受票方：","姓名"]
[null,"日期：","日期",{"$nulls":3},"公司名称"]
[null,"客户 ID：","客户 ID",{"$nulls":3},"街道地址"]
[null,"所附汇款金额：",null,"汇款金额",null,null,"地址 2"]
[{"$nulls":6},"省/市/自治区，市/县 邮政编码"]
[null,"日期","类型","发票编号","说明","金额","还款额","余额"]
[{"$nulls":7},{"$f":"IFERROR(IF(F12>0,F12-G12,\"\"), \"\")","v":""}]
[{"$nulls":7},{"$f":"IFERROR(IF(F13>0,F13-G13,\"\"), \"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":6},"总计",{"$f":"SUBTOTAL(109,发票[余额])","v":0}]
[null,"提醒：请在支票上附上结算编号。"]
[null,"条款：应付余额期限为 30 天。"]
[]
[null,"汇款单"]
[null,"客户姓名：",null,{"$f":"客户_姓名","v":"姓名"}]
[null,"客户 ID：",null,{"$f":"客户_ID","v":"客户 ID"}]
[null,"结算编号：",null,{"$f":"结算_编号","v":"结算编号"}]
[null,"日期：",null,{"$f":"结算_日期","v":"日期"}]
[null,"应付金额：",null,{"$f":"应付款_总额","v":0}]
[null,"所附金额：",null,{"$f":"汇款_金额","v":"汇款金额"}]