{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["帳單明細"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"帳單明細","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"merged":[[1,2,1,3],[1,6,1,7],[2,2,2,3],[2,6,2,7],[3,2,3,3],[3,6,3,7],[5,2,5,3],[5,6,5,7],[6,2,6,3],[6,6,6,7],[7,2,7,3],[7,6,7,7],[8,6,8,7],[9,6,9,7]]}
[null,"公司名稱"]
[null,"街道地址",{"$nulls":3},"電話："]
[null,"地址 2",{"$nulls":3},"傳真："]
[null,"郵遞區號，縣/市",{"$nulls":3},"電子郵件："]
[null,"對帳單"]
[null,"對帳單號碼：",null,null,"付款人：","姓名"]
[null,"日期：",{"$nulls":3},"公司名稱"]
[null,"客戶識別碼：",{"$nulls":3},"街道地址"]
[{"$nulls":5},"地址 2"]
[{"$nulls":5},"郵遞區號，縣/市"]
[]
[null,"日期","類型","發票號碼","描述","金額","還款","餘額"]
[null,{"$f":"TODAY()","v":"2022-08-18"},"銷售",123,"產品",{"v":200,"d":"NT$200.00"},{"v":100,"d":"NT$100.00"},{"$f":"IF(資料[[#This Row],[金額]]>0,資料[[#This Row],[金額]]-資料[[#This Row],[還款]],\"\")","v":{"v":100,"d":"NT$100.00"}}]
[{"$nulls":7},{"$f":"IF(資料[[#This Row],[金額]]>0,資料[[#This Row],[金額]]-資料[[#This Row],[還款]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(資料[[#This Row],[金額]]>0,資料[[#This Row],[金額]]-資料[[#This Row],[還款]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(資料[[#This Row],[金額]]>0,資料[[#This Row],[金額]]-資料[[#This Row],[還款]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(資料[[#This Row],[金額]]>0,資料[[#This Row],[金額]]-資料[[#This Row],[還款]],\"\")","v":""}]
[{"$nulls":6},"合計",{"$f":"SUBTOTAL(109,資料[餘額])","v":{"v":100,"d":"NT$100.00"}}]
[null,"提醒：請在支票上附上對帳單號碼。"]
[null,"付款期限：應付餘額於 30 天內到期。"]
[null,"匯款"]
[null,"客戶名稱："]
[null,"客戶識別碼："]
[null,"對帳單號碼："]
[null,"日期："]
[null,"應付金額：",{"$f":"資料[[#Totals],[餘額]]","v":{"v":100,"d":"NT$100.00"}}]
[null,"本次付款金額："]