{"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":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":39,"n_cols":8,"rows_kept":39,"merged":[[0,1,0,3],[0,4,0,7],[1,1,1,6],[2,1,2,3],[3,1,3,3],[4,1,4,2],[4,5,4,6],[5,1,5,2],[5,5,5,6],[6,1,6,2],[6,3,6,4],[6,5,6,6],[7,1,7,2],[7,3,7,4],[8,2,8,3],[8,5,8,6],[9,2,9,3],[9,5,9,6],[10,2,10,3],[10,5,10,6],[11,2,11,3],[11,5,11,6],[12,2,12,3],[12,5,12,6],[37,1,37,3],[37,4,37,7],[38,1,38,7]]}
["在此工作表中创建销售发票。在单元格右侧输入公司标语，在单元格 E1 中输入此工作表的标题。此列的单元格中显示有关如何使用此工作表的有用说明。下一条说明位于单元格 A3 中。","徽标占位符位于此单元格中。",null,null,"发票"]
[]
["在右侧单元格中输入公司名称。","你的公司名称"]
["在右侧单元格中输入公司标语。","公司标语"]
["在右侧单元格中输入省/市/自治区、市/县和邮政编码，在单元格 E5 中输入发票编号。","省/市/自治区，市/县",null,null,"发票编号","否"]
["在右侧单元格中输入公司街道地址，在单元格 E6 中输入开票日期。","街道地址，邮政编码",null,null,"日期",{"$f":"TODAY()","v":"2019-05-08"}]
["在右侧单元格中输入电话和传真号码，在单元格 F7 中输入客户 ID。","电话传真",null,"客户 ID",null,"ID"]
["在右侧单元格中输入电子邮件地址。","电子邮件"]
["在单元格 C9 到 C13 中输入受票方详细信息，在 F9 到 F13 中输入配送地址详细信息。下一条说明位于单元格 A14 中。","受票方","姓名",null,"配送地址","姓名"]
[null,null,"公司名称",null,null,"公司名称"]
[null,null,"邮政编码 省/市/自治区，市/县",null,null,"邮政编码 省/市/自治区，市/县"]
[null,null,"街道地址",null,null,"街道地址"]
[null,null,"电话",null,null,"电话"]
["在“详细信息”表中的右侧单元格开始输入相关信息。下一条说明位于单元格 A17 中。","销售人员","职务","配送方式","配送条款","交付日期","付款方式","截止日期"]
[{"$nulls":6},"见票付款"]
[]
["在发票表中从右侧单元格开始输入相关信息。最后自动计算小计和总计。下一条说明位于单元格 A38 中。","数量","商品编号","说明","自定义列","单价","折扣","行合计"]
[{"$nulls":7},{"$f":"IF(SUM(B18)>0,SUM(B18*F18-G18),\"\")","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":5},"总折扣",{"$f":"IF(SUM(G18:G32)>0,SUM(G18:G32),\"\")","v":""}]
[{"$nulls":6},"小计",{"$f":"IF(SUM(H18:H32)>0,SUM(H18:H32),\"\")","v":""}]
[{"$nulls":6},"销售税"]
[{"$nulls":6},"汇总",{"$f":"IF(SUM(H34)>0,SUM((H34*H35)+H34),\"\")","v":""}]
[]
["公司名称会在单元格 F38 中自动更新。","所有支票支付给",null,null,{"$f":"B3","v":"你的公司名称"}]
["右侧单元格显示“感谢你”消息。","谢谢惠顾！"]