{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["統一發票明細表","基本資料"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"統一發票明細表","index":0,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,3,5,4],[5,5,5,7],[2,6,2,7],[6,1,6,6],[0,1,0,6],[3,5,3,6],[3,3,3,4],[4,3,4,4]]}
[null,"營業人使用電子計算機統一發票明細表"]
[null,null,null,"資料期間 :","107年","01-02 月"]
[null,null,null,null,null,null,{"$f":"\"列印日\" &TEXT( TODAY(),\"yyyy/mm/dd\")","v":"列印日2018/03/09"}]
[null,{"$f":"IF(D4=\"\",\"\",VLOOKUP($D$4,基本資料!$A$2:$D$3,4))","v":100},"統一編號",12345678]
[null,null,"營業人名稱",{"$f":"IF(D4=\"\",\"\",VLOOKUP($D$4,基本資料!$A$2:$D$3,2))","v":"測試公司"},null,null,"發 票字 軌","ZT"]
[null,null,"稅籍編號",{"$f":"IF(D5=\"\",\"\",VLOOKUP($D$4,基本資料!$A$2:$D$3,3))","v":0},null,"所屬年月及發票字軌請營業人填註"]
[]
[null,"NO","發票日期","發票號碼","銷售額","稅額(非營業人免填)","作廢發票號碼","B/C"]

{"sheet":"基本資料","index":1,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["統一編號","公司名稱","稅籍","發票數"]
[12345678,"測試公司",null,100,null,null,{"$f":"YEAR(NOW())-1911 & \"年\"","v":"107年"},"01-02 月"]
[null,null,null,null,null,null,{"$f":"YEAR(NOW())-1912 & \"年\"","v":"106年"},"03-04 月"]
[null,null,null,null,null,null,null,"05-06 月"]
[null,null,null,null,null,null,null,"07-08 月"]
[null,null,null,null,null,null,null,"09-10 月"]
[null,null,null,null,null,null,null,"11-12 月"]