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

{"sheet":"服务发票","index":0,"n_rows":30,"n_cols":5,"rows_kept":30,"merged":[[0,3,0,4],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[26,1,26,2],[27,1,27,3],[28,1,28,4],[29,1,29,4]]}
[null,null,"公司标语","发票"]
[null,"公司名称"]
[null,"街道地址",null,"发票编号:",100]
[null,"省/直辖市/自治区、市/县  邮政编码",null,"日期:",{"$f":"TODAY()","v":"2018-08-23"}]
[null,"[电话] [传真]",null,"客户 ID:","ABC12345"]
[null,"电子邮件"]
[null,"姓名"]
[null,"公司名称"]
[null,"街道地址"]
[null,"省/直辖市/自治区、市/县  邮政编码"]
[null,"电话"]
[null,"销售人员","工作","付款方式","截止日期"]
[{"$nulls":3},"收到收据后付款"]
[]
[null,"数量","说明","单价","行合计"]
[{"$nulls":4},{"$f":"IFERROR(IF(SUM(B16)>0,SUM(B16*D16),\"\"), \"\")","v":""}]
[{"$nulls":4},{"$f":"IFERROR(IF(SUM(B17)>0,SUM(B17*D17),\"\"), \"\")","v":""}]
[{"$nulls":4},""]
[null,null," ",null,""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":3},"小计",{"$f":"IFERROR(IF(SUM(E16:E25)>0,SUM(E16:E25),\"\"), \"\")","v":""}]
[null,"销售税率",null,{"v":0.095,"d":"9.50%"},{"$f":"IFERROR(IF(SUM(发票[[#Totals],[行合计]])>0,SUM(发票[[#Totals],[行合计]]*D27),\"\"), \"\")","v":""}]
[null,"汇总",null,null,{"$f":"IFERROR(IF(SUM(发票[[#Totals],[行合计]])>0,SUM(发票[[#Totals],[行合计]],E27),\"\"), \"\")","v":""}]
[null,{"$f":"\"各项应付支票和公司名称\"&Company_Name&\".\"","v":"各项应付支票和公司名称公司名称."}]
[null,"合作愉快！"]

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