{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["开始日期","销售收据"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"开始日期","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"模板简介"]
[null,"利用此模板创建简单的销售收据。"]
[null,"请填写公司名称、付款方式、支票编号和买家详细信息。"]
[null,"在表中输入详细信息，之后将自动计算出总额。"]
[null,"注意： "]
[null,"销售收据工作表的 A 列中提供了额外说明。已故意隐藏此文本。若要删除文本，请选择 A 列，然后选择“删除”。"]
[null,"若要了解有关表格的详细信息，请在表格内按 Shift + F10，选择“表格”选项，然后选择“替换文本”。"]

{"sheet":"销售收据","index":1,"n_rows":44,"n_cols":7,"rows_kept":44,"merged":[[1,1,1,2],[1,3,1,6],[4,2,4,3],[5,2,5,3],[5,4,5,5],[6,2,6,3],[6,4,6,5],[7,2,7,3],[7,4,7,5],[8,2,8,3],[8,4,8,5],[10,1,10,2],[10,4,10,6],[11,1,11,2],[11,4,11,6],[42,1,42,6],[43,1,43,6],[46,2,46,4]]}
[]
[null,"徽标占位符位于此单元格中。",null,"销售收据"]
[null,"你的公司名称",{"$nulls":3},"日期:",{"$f":"TODAY()","v":"2022-05-30"}]
[null," 在此处键入公司标语",{"$nulls":3},"发票编号:","否"]
[null,"买家:","姓名"]
[null,null,"公司名称"]
[null,null,"邮政编码 省/市/自治区，市/县"]
[null,null,"街道地址"]
[null,null,"电话"]
[]
[null,"支付方式",null,"支票编号","工作"]
[]
[]
[null,"数量","商品编号","说明","单价","折扣","行合计"]
[{"$nulls":6},{"$f":"IF(SUM(B15)>0,SUM((B15*E15)-F15),\"\")","v":""}]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":4},"总折扣",{"$f":"IF(SUM(F16:F37)>0,SUM(F16:F37),\"\")","v":""}]
[{"$nulls":5},"小计",{"$f":"IF(SUM(G16:G37)>0,SUM(G16:G37),\"\")","v":""}]
[{"$nulls":5},"销售税"]
[null," ",{"$nulls":3},"汇总",{"$f":"IF(SUM(G39)>0,SUM((G39*G40)+G39),\"\")","v":""}]
[]
[null,"谢谢惠顾！"]
[null,"邮政编码 省/市/自治区，市/县，街道地址   电话   传真   电子邮件"]