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

{"sheet":"开始日期","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"模板简介"]
[null,"利用此模板创建简单的销售发票。"]
[null,"填写公司名称、受票方和配送地址详情等基本信息。"]
[null,"在表中输入详细信息。"]
[null,"总额自动计算得出。"]
[null,"注意： "]
[null,"销售发票工作表的 A 列中提供了额外说明。已故意隐藏此文本。若要删除文本，请选择 A 列，然后选择“删除”。若要取消隐藏文本，请选择 A 列，然后更改字体颜色。"]
[null,"若要了解有关表格的详细信息，请在表格内按 Shift + F10，选择“表格”选项，然后选择“替换文本”。"]

{"sheet":"销售发票","index":1,"n_rows":44,"n_cols":8,"rows_kept":44,"merged":[[1,1,1,3],[1,4,1,7],[2,5,2,6],[3,1,4,4],[3,5,3,6],[4,5,4,6],[5,2,5,3],[5,5,5,6],[6,2,6,3],[6,5,6,6],[7,2,7,3],[7,5,7,6],[8,2,8,3],[8,5,8,6],[9,2,9,3],[9,5,9,6],[13,1,13,7],[41,1,41,3],[41,4,41,7],[42,1,42,7],[43,1,43,7]]}
[]
[{"$nulls":4},"发票"]
[null,"你的公司名称",{"$nulls":3},"日期：",null,{"$f":"TODAY()","v":"2022-05-09"}]
[null," 在此处键入公司标语",{"$nulls":3},"发票编号:  ",null,"编号"]
[{"$nulls":5},"客户 ID：",null,"ID"]
[null,"受票方:","姓名",null,"配送地址：","姓名"]
[null,null,"公司名称",null,null,"公司名称"]
[null,null,"邮政编码 省/市/自治区，市/县",null,null,"邮政编码 省/市/自治区，市/县"]
[null,null,"街道地址",null,null,"街道地址"]
[null,null,"电话",null,null,"电话"]
[]
[null,"销售人员","职务","配送方式","配送条款","交付日期","付款方式","截止日期"]
[]
[]
[null,"数量","商品编号","说明","自定义列","单价","折扣","行合计"]
[{"$nulls":7},{"$f":"IF(SUM(B16)>0,SUM((B16*F16)-G16),\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(SUM(B17)>0,SUM((B17*F17)-G17),\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},{"$f":"IF(SUM(B34)>0,SUM((B34*F34)-G34),\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":5},"总折扣",{"$f":"IF(SUM(G16:G36)>0,SUM(G16:G36),\"\")","v":""}]
[{"$nulls":6},"小计",{"$f":"IF(SUM(H16:H36)>0,SUM(H16:H36),\"\")","v":""}]
[{"$nulls":6},"销售税"]
[{"$nulls":6},"总计",{"$f":"IF(SUM(H38)>0,SUM((H38*H39)+H38),\"\")","v":""}]
[]
[null,"各项应付支票",null,null,{"$f":"B3","v":"你的公司名称"}]
[null,"谢谢惠顾！"]
[null,"邮政编码 省/市/自治区，市/县，街道地址   电话   传真   电子邮件"]