{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["服务发票","如何使用此模板"],"not_rendered":{"images":5,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"服务发票","index":0,"n_rows":42,"n_cols":7,"rows_kept":42,"merged":[[0,2,0,3],[0,4,0,6],[1,1,1,2],[1,3,1,6],[3,2,3,3],[3,5,3,7],[4,2,4,3],[5,2,5,3],[6,2,6,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,1,13,6],[14,4,14,5],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[40,2,40,6],[41,2,41,6],[43,2,43,5]]}
[null,null,"[公司宣传语]",null,"服务发票"]
[]
[null,null,"[公司名称]"]
[null,null,"[街道地址]",null,"发票编号：","[100]"]
[null,null,"[省/市/自治区，市/县，邮政编码]",null,"日期：",{"$f":"TODAY()","v":"2012-05-30"}]
[null,null,"[电话] [传真]",null,"客户 ID：","[ABC12345]"]
[null,null,"[电子邮件]"]
[]
[null,"TO","[姓名]"]
[null,null,"[公司名称]"]
[null,null,"[街道地址]"]
[null,null,"[省/市/自治区，市/县，邮政编码]"]
[null,null,"[电话]"]
[]
[null,null,"销售人","职位","付款方式",null,"截止日期"]
[{"$nulls":4},"见票即付"]
[]
[null,"QUANTITY","数量","说明",null,"单价","行合计"]
[{"$nulls":6},{"$f":"IF(SUM(C19)>0,SUM(C19*F19),\"\")","v":""}]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":3}," ",null,null,""]
[{"$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":5},"小计",{"$f":"IF(SUM(G19:G37)>0,SUM(G19:G37),\"\")","v":""}]
[{"$nulls":4},"销售税 @",{"v":0.095,"d":"9.50%"},{"$f":"IF(SUM(G38)>0,SUM(G38*F39),\"\")","v":""}]
[{"$nulls":5},"总计",{"$f":"IF(SUM(G38)>0,SUM(G38,G39),\"\")","v":""}]
[null,null,"所有支票支付给 [公司名称]"]
[null,null,"谢谢您的惠顾！"]

{"sheet":"如何使用此模板","index":1,"n_rows":2,"n_cols":2,"rows_kept":2}
[]
[null,"开始使用服务发票\n\n使用此模板创建具有专业外观、易于填写且方便客户阅读的发票。\n\n首先，在上半部分中，在“服务发票”选项卡的单元格 C3 至 C7 中键入公司名称、地址和电话信息，然后将该模板另存为 Excel 模板 (.xltx)，以便该模板始终在这些单元格中预填充了此信息。确保将模板保存在您可轻松访问的某个位置。如果将其保存在计算机的模板文件夹（通常是 C:\\Users\\<用户名>\\AppData\\Roaming\\Microsoft\n\\Templates）中，则可通过依次单击“新建”、“我的模板”来轻松访问它。否则，您可以单击“根据现有内容新建”，然后浏览并打开 .xltx 文件。无论是哪种方法，当第一次保存文件时，系统都会提示您将其另存为 .xlsx 工作簿。\n\n输入发票编号和客户 ID。系统将自动填充日期。然后输入客户信息 -- 联系人姓名、公司名称、地址和电话信息。在单元格 F39 中设置税率。在单元格 C41 中输入公司\n名称。最后，在单元格 C19 至 F39 中输入所有订单交易信息。"]