{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["匯入作業說明","發票版標準版","log","初始值"],"not_rendered":{"charts":0,"images":8,"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":5,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"操作步驟","示範圖例 說明","我已經清楚巨集操作"]
[null,1,"新版範本 含有免費升級許多功能。建議優先使用\n這個檔案含有檢查與轉換格式的巨集程式。\n建議使用該巨集減少發票開立錯誤問題。\n請允許啟動 EXCEL 的編輯與巨集程式權限",null,"第一次執行匯出後\n不再出現此說明頁"]
[null,2,"剛下載請先將這份EXCEL 選定你經常作業目錄後另存"]
[null,3,"第一列上有巨集按鈕可以方便作業。\n你可以設定 產出的EXCEL 匯出檔的路徑(方便匯入時找到檔案)。\n可以清空測試資料。\n可以利用隱藏不常用欄位作為貼入或輸入的方便選擇。",null,"無法執行巨集\nEXCEL巨集安全性設定"]
[null,4,"你可以將要開立的發票資料貼入或是輸入(注意訂單號碼重複不匯入)"]
[null,5,"重要 輸入完畢後點選 檢查與轉出(會產生一個純文字的匯入檔)。\n巨集協助檢查一些必要欄位是否遺漏與填寫錯誤，金額是否計算錯誤。\n也將格式中文數字轉換成標準匯入格式，避免錯誤。"]
[null,6,"到e首發票後台匯入上述產生的純文字的匯入檔 開立電子發票。\n不是匯入原來巨集的檔案。"]

{"sheet":"發票版標準版","index":1,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["InvoiceProcessStatus","InvoiceID","UTCInvoiceDateTime","InvoiceDateTime","InvoiceFor","BuyerID","BuyerInvoiceTitle","BuyerName","BuyerTelNo","BuyerEmailAddress","BuyerAddress","CheckNumber","RandomNumber","RelateNumber","BillingNo","NPOBAN","CarrierId","CarrierType","DeptID","SalesID","TaxType","SalesAmount","TaxAmount","TotalAmount","MainRemark","DetailID","ProductID","ProductName","Quantity","UnitPrice","SubTotal","Remark","CustomsClearanceMark","BondedArea","ItemTaxDiff","Unit","BuyerCustomerNumber","CompanyID","PrintMark"]
["開立狀態\n開立 I","輸入發票號","發票日期\n(格式2017-07-01)\n","發票時間\n無則預設\n上傳時間","B(稅外加)\nC類(稅內含)","B類必填/可填00000000","B類必填","選填(16)","選填(16)","選填(50)","選填(100)","B類發票用\n選填(4)","C類發票用\n選填(4)","選填(16)","選填(20)","必須正確\n選填","必須正確\n選填","必須正確\n選填","選填(9)","選填(10)","1:應稅 2:零稅率 3:免稅","B類總合(未稅)，C為(含稅)。","銷售額*0.05。C類為0。","銷售總額+總稅額之和","選填(100)","格式 001~999\n選填(3)","選填(20)","必填(256)","必填(支援小數7位)","必填(支援小數7位)","必填(支援小數7位)","選填(40)","1：非經海關出口\n2：經海關出口\n(零稅率必填)"," 1:保稅區營業人 2:遠洋漁業3:自由貿易港區 選填(1)","產品單價如非預設Y。未設定為N","選填(4)","選填(20)","自動處理必填","C類列印必填\"Y\"\n預設 N"]
["發票作業","發票字軌號碼","發票日期UTC","發票開立時間","發票對象","買方統編","買方抬頭","買受人名稱","買方電話號碼","買方電子郵件帳號","買方地址","檢查碼","隨機碼","關聯號碼","帳單編號","愛心碼","載具編號","載具類型","部門","業務人員","課稅別","銷售總額","總稅額","總金額","發票總備註","三碼項次編碼","產品代碼","產品名稱","數量","單價","小計","明細備註","通關方式列表","零稅率註記","單價稅額異常註記","單位","客戶編號","賣方統編","列印否"]
["I","TT17832147","2023-10-17T12:52:43.170",null,"B","77788899","單筆有限公司","李一筆","0900-000-000","Lee@Nogmail.com","900屏東市","","","PO-736592","BIL-365928","","","",null,null,"1",5000,250,"5250","","001","","好產品一","10",355.2,3552]
["I","TT17832148","2023-10-17T12:52:43.170","","C",null,null,"陳客戶","0988-888-888","lotus@gmail.nomail","900屏東市","","","PO-736592","BIL-365929","","","",null,"D7493 陳奕田","1","900",0,"900","","001","","文具一","20",45,900]
["I","TT17832149","2023-10-17T12:52:43.170","","C","43218765","國立高級中學","顏如珊","0932-333-333","Cathy@gmail.com","900屏東市","","","PO-736593","BIL-365930","","","",null,"H6582 湯享","1","900","0","900","","001","","文具二","50",18,900]
["I","TT17832150","2023-10-17T12:52:43.170","","B","87654321","多筆股份有限公司","多筆股份有限公司","0999-999-999","Rose@hotmail.nomail","100台北市","","","PO-736593","BIL-365931","","","",null,null,"1",137000,6850,"143850","","001","","雷射滑鼠一","10",223.8,2238]
["I","TT17832150","2023-10-17T12:52:43.170","","B","87654321","多筆股份有限公司","多筆股份有限公司","0999-999-999","Rose@hotmail.nomail","100台北市","","","PO-736593","BIL-365931","","","",null,null,"1",137000,6850,"143850","","002","","雷射滑鼠二","5",186.4,932]
["I","TT17832150","2023-10-17T12:52:43.170","","B","87654321","多筆股份有限公司","多筆股份有限公司","0999-999-999","Rose@hotmail.nomail","100台北市","","","PO-736593","BIL-365931","","","",null,null,"1",137000,6850,"143850","","003","","雷射滑鼠三","5",112,560]
["I","TT17832150","2023-10-17T12:52:43.170","","B","87654321","多筆股份有限公司","多筆股份有限公司","0999-999-999","Rose@hotmail.nomail","100台北市","","","PO-736593","BIL-365931","","","",null,null,"1",137000,6850,"143850","","004","","雷射滑鼠四","10",149.30000000000001,1493]
["I","TT17832150","2023-10-17T12:52:43.170","","B","87654321","多筆股份有限公司","多筆股份有限公司","0999-999-999","Rose@hotmail.nomail","100台北市","","","PO-736593","BIL-365931","","","",null,null,"1",137000,6850,"143850","","005","","光學滑鼠一","10",223.8,2238]
["I","TT17832150","2023-10-17T12:52:43.170","","B","87654321","多筆股份有限公司","多筆股份有限公司","0999-999-999","Rose@hotmail.nomail","100台北市","","","PO-736593","BIL-365931","","","",null,null,"1",137000,6850,"143850","","006","","光學滑鼠二","100",164.2,16416]
["I","TT17832150","2023-10-17T12:52:43.170","","B","87654321","多筆股份有限公司","多筆股份有限公司","0999-999-999","Rose@hotmail.nomail","100台北市","","","PO-736593","BIL-365931","","","",null,null,"1",137000,6850,"143850","","007","","電腦一","3",37707.699999999997,113123]
["I","TT17832151","2023-10-17T12:52:43.170","","C","12345678","12345","王三比","0933-333-333","lotus@gmail.nomail","830高雄市鳳山區","","","PO-736593","BIL-365932","","","",null,null,"1","14095",0,"14095","","001","","服飾A","1",543.9,518]
["I","TT17832151","2023-10-17T12:52:43.170","","C","12345678","12345","王三比","0933-333-333","lotus@gmail.nomail","830高雄市鳳山區","","","PO-736593","BIL-365932","","","",null,null,"1","14095",0,"14095","","002","","服飾B","10",85008,8096]
["I","TT17832151","2023-10-17T12:52:43.170","","C","12345678","12345","王三比","0933-333-333","lotus@gmail.nomail","830高雄市鳳山區","","","PO-736593","BIL-365932","","","",null,null,"1","14095",0,"14095","","003","","服飾C","5",1096.2,5481]

{"sheet":"log","index":2,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["日期時間","單號","預設目錄","C:\\TEMP"]

{"sheet":"初始值","index":3,"n_rows":14,"n_cols":35,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["發票作業","發票字軌號碼","發票開立UTC日期","發票開立時間","發票開立對象:B類/C類","買方統編","買方抬頭","買受人名稱","買方電話號碼","買方電子郵件帳號","買方地址","檢查碼","隨機碼","關聯號碼","帳單編號","愛心碼","載具編號","載具類型","部門","業務人員","課稅別","銷售總額","總稅額","總金額","發票總備註","三碼項次編碼","產品代碼","產品名稱","數量","單價","小計","明細備註","通關方式列表","零稅率註記","單價稅額異常註記"]
["I",{"$f":"\"TT\" & TEXT(RAND()*103000003,\"00000000\")","v":"TT90339594"},{"$f":"NOW()","v":"2023-10-17T12:54:44.090"},null,"B","77788899","單筆有限公司","李一筆","0900-000-000","Lee@Nogmail.com","900屏東市","","","PO-736592","BIL-365928","","","",null,null,"1",5000,250,"5250","","001","","好產品一","10",355.2,3552]
["I",{"$f":"\"TT\"&TEXT(VALUE(MID(B2,3,8))+1,\"00000000\")","v":"TT90339595"},{"$f":"NOW()","v":"2023-10-17T12:54:44.090"},"","C",null,null,"陳客戶","0988-888-888","lotus@gmail.nomail","900屏東市","","","PO-736592","BIL-365929","","","",null,"D7493 陳奕田","1","900",0,"900","","001","","文具一","20",45,900]
["I",{"$f":"\"TT\"&TEXT(VALUE(MID(B3,3,8))+1,\"00000000\")","v":"TT90339596"},{"$f":"NOW()","v":"2023-10-17T12:54:44.090"},"","C","43218765","國立高級中學","顏如珊","0932-333-333","Cathy@gmail.com","900屏東市","","","PO-736593","BIL-365930","","","",null,"H6582 湯享","1","900","0","900","","001","","文具二","50",18,900]
["I",{"$f":"\"TT\"&TEXT(VALUE(MID(B4,3,8))+1,\"00000000\")","v":"TT90339597"},"2023-10-17T12:54:44.090","","B","87654321","多筆股份有限公司","多筆股份有限公司","0999-999-999","Rose@hotmail.nomail","100台北市","","","PO-736593","BIL-365931","","","",null,null,"1",137000,6850,"143850","","001","","雷射滑鼠一","10",223.8,2238]
["I",{"$f":"\"TT\"&TEXT(VALUE(MID(B5,3,8)),\"00000000\")","v":"TT90339597"},"2023-10-17T12:54:44.090","","B","87654321","多筆股份有限公司","多筆股份有限公司","0999-999-999","Rose@hotmail.nomail","100台北市","","","PO-736593","BIL-365931","","","",null,null,"1",137000,6850,"143850","","002","","雷射滑鼠二","5",186.4,932]
["I",{"$f":"\"TT\"&TEXT(VALUE(MID(B6,3,8)),\"00000000\")","v":"TT90339597"},"2023-10-17T12:54:44.090","","B","87654321","多筆股份有限公司","多筆股份有限公司","0999-999-999","Rose@hotmail.nomail","100台北市","","","PO-736593","BIL-365931","","","",null,null,"1",137000,6850,"143850","","003","","雷射滑鼠三","5",112,560]
["I","TT90339597","2023-10-17T12:54:44.090","","B","87654321","多筆股份有限公司","多筆股份有限公司","0999-999-999","Rose@hotmail.nomail","100台北市","","","PO-736593","BIL-365931","","","",null,null,"1",137000,6850,"143850","","004","","雷射滑鼠四","10",149.30000000000001,1493]
["I","TT90339597","2023-10-17T12:54:44.090","","B","87654321","多筆股份有限公司","多筆股份有限公司","0999-999-999","Rose@hotmail.nomail","100台北市","","","PO-736593","BIL-365931","","","",null,null,"1",137000,6850,"143850","","005","","光學滑鼠一","10",223.8,2238]
["I","TT90339597","2023-10-17T12:54:44.090","","B","87654321","多筆股份有限公司","多筆股份有限公司","0999-999-999","Rose@hotmail.nomail","100台北市","","","PO-736593","BIL-365931","","","",null,null,"1",137000,6850,"143850","","006","","光學滑鼠二","100",164.2,16416]
["I","TT90339597","2023-10-17T12:54:44.090","","B","87654321","多筆股份有限公司","多筆股份有限公司","0999-999-999","Rose@hotmail.nomail","100台北市","","","PO-736593","BIL-365931","","","",null,null,"1",137000,6850,"143850","","007","","電腦一","3",37707.699999999997,113123]
["I",{"$f":"\"TT\"&TEXT(VALUE(MID(B11,3,8)+1),\"00000000\")","v":"TT90339598"},"2023-10-17T12:54:44.090","","C","12345678","12345","王三比","0933-333-333","lotus@gmail.nomail","830高雄市鳳山區","","","PO-736593","BIL-365932","","","",null,null,"1","14095",0,"14095","","001","","服飾A","1",543.9,518]
["I","TT90339598","2023-10-17T12:54:44.090","","C","12345678","12345","王三比","0933-333-333","lotus@gmail.nomail","830高雄市鳳山區","","","PO-736593","BIL-365932","","","",null,null,"1","14095",0,"14095","","002","","服飾B","10",85008,8096]
["I","TT90339598","2023-10-17T12:54:44.090","","C","12345678","12345","王三比","0933-333-333","lotus@gmail.nomail","830高雄市鳳山區","","","PO-736593","BIL-365932","","","",null,null,"1","14095",0,"14095","","003","","服飾C","5",1096.2,5481]