{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["銷售發票"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"銷售發票","index":0,"n_rows":47,"n_cols":7,"rows_kept":47,"merged":[[0,1,0,6],[2,0,2,2],[3,0,4,2],[7,1,7,2],[7,4,7,5],[8,1,8,2],[8,4,8,5],[15,0,15,6],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[36,2,36,3],[37,2,37,3],[38,3,38,4],[39,0,41,4],[43,0,44,6],[46,0,46,6]]}
[null,"發票"]
[]
["[公司名稱]",{"$nulls":4},"日期：",{"$f":"TODAY()","v":"2012-07-12"}]
[" [公司標語]",{"$nulls":4},"發票號碼：","[100]"]
[{"$nulls":5},"客戶編號：","[ABC12345]"]
[]
[]
["收件者：","[姓名]",null,"送貨地址：","[姓名]"]
[null,"[公司名稱]",null,null,"[公司名稱]"]
[null,"[郵遞區號，縣/市]",null,null,"[郵遞區號，縣/市]"]
[null,"[街道地址]",null,null,"[街道地址]"]
[null,"[電話]",null,null,"[電話]"]
[]
["銷售人員","職稱","交貨方式","交貨條件","交貨日期","付款條件","到期日"]
[]
[]
["數量","貨號","說明",null,"單價","折扣","項目合計"]
[{"$nulls":6},{"$f":"IF(SUM(A18)>0,SUM((A18*E18)-F18),\"\")","v":""}]
[{"$nulls":6},{"$f":"IF(SUM(A19)>0,SUM((A19*E19)-F19),\"\")","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":3},"折扣總計",null,{"$f":"IF(SUM(F18:F38)>0,SUM(F18:F38),\"\")","v":""}]
[{"$nulls":5},"小計",{"$f":"IF(SUM(G18:G38)>0,SUM(G18:G38),\"\")","v":""}]
[{"$nulls":5},"營業稅"]
[{"$nulls":5},"總計",{"$f":"IF(SUM(G40)>0,SUM((G40*G41)+G40),\"\")","v":""}]
[]
["支票抬頭為 [您的公司名稱]\n感謝您的惠顧！"]
[]
[]
["[郵遞區號，縣/市]，[街道地址]  [電話]  [傳真]  [電子郵件]"]