{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["商业发票","客户"],"not_rendered":{"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"商业发票","index":0,"n_rows":19,"n_cols":10,"rows_kept":19,"merged":[[0,1,1,3],[0,6,0,7],[1,6,1,7]]}
[null,"TAILSPIN TOYS",null,null,"123 Main Street","电话：123-555-0123","tailspin@interestingsite.com",null,null,"客户"]
[{"$nulls":4},"Ocean View,  MO 12345","传真：123-555-0124","www.tailspintoys.com"]
[]
[null,"受票方：","Lilli Allik","电话号码：",{"$f":"IFERROR(VLOOKUP(BillName,CustomerList[],8,FALSE),\"\")","v":"432-555-0178"},null,"发票编号：",34567]
[null,"地址：",{"$f":"IFERROR(VLOOKUP(BillName,CustomerList[],3,FALSE),\"\")","v":"345 Cherry Street"},"传真：",{"$f":"IFERROR(VLOOKUP(BillName,CustomerList[],10,FALSE),\"\")","v":"432-555-0187"},null,"发票日期：",{"$f":"TODAY()","v":"2022-12-14"}]
[null,null,{"$f":"IF(VLOOKUP(BillName,CustomerList[],4,FALSE)<>\"\",VLOOKUP(BillName,CustomerList[],4,FALSE),IF(VLOOKUP(BillName,CustomerList[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(BillName,CustomerList[],5,FALSE),\", \",VLOOKUP(BillName,CustomerList[],6,FALSE),\" \",VLOOKUP(BillName,CustomerList[],7,FALSE)),CONCATENATE(VLOOKUP(BillName,CustomerList[],6,FALSE),\" \",VLOOKUP(BillName,CustomerList[],7,FALSE))))","v":"Suite 123"},"电子邮件：",{"$f":"IFERROR(VLOOKUP(BillName,CustomerList[],9,FALSE),\"\")","v":"mike@excellentwebsite.com"},null,"联系人：",{"$f":"IFERROR(VLOOKUP(BillName,CustomerList[],2,FALSE),\"\")","v":"Mike Gragg"}]
[null,null,{"$f":"IF(VLOOKUP(BillName,CustomerList[],4,FALSE)=\"\",\"\",IF(VLOOKUP(BillName,CustomerList[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(BillName,CustomerList[],5,FALSE),\", \",VLOOKUP(BillName,CustomerList[],6,FALSE),\" \",VLOOKUP(BillName,CustomerList[],7,FALSE)),CONCATENATE(VLOOKUP(BillName,CustomerList[],6,FALSE),\" \",VLOOKUP(BillName,CustomerList[],7,FALSE))))","v":"奥尔巴尼, SD 12345"}]
[null,"日期","商品编号","说明","数量","单价","折扣","总计"]
[null,{"$f":"TODAY()","v":"2022-12-14"},789807,"木块",4,{"v":10,"d":"¥10.00"},{"v":2,"d":"¥2.00"},{"$f":"IF(AND(InvoiceItems[[#This Row],[数量]]<>\"\",InvoiceItems[[#This Row],[单价]]<>\"\"),(InvoiceItems[[#This Row],[数量]]*InvoiceItems[[#This Row],[单价]])-InvoiceItems[[#This Row],[折扣]],\"\")","v":{"v":38,"d":"¥38.00"}}]
[{"$nulls":7},{"$f":"IF(AND(InvoiceItems[[#This Row],[数量]]<>\"\",InvoiceItems[[#This Row],[单价]]<>\"\"),(InvoiceItems[[#This Row],[数量]]*InvoiceItems[[#This Row],[单价]])-InvoiceItems[[#This Row],[折扣]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(InvoiceItems[[#This Row],[数量]]<>\"\",InvoiceItems[[#This Row],[单价]]<>\"\"),(InvoiceItems[[#This Row],[数量]]*InvoiceItems[[#This Row],[单价]])-InvoiceItems[[#This Row],[折扣]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(InvoiceItems[[#This Row],[数量]]<>\"\",InvoiceItems[[#This Row],[单价]]<>\"\"),(InvoiceItems[[#This Row],[数量]]*InvoiceItems[[#This Row],[单价]])-InvoiceItems[[#This Row],[折扣]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(InvoiceItems[[#This Row],[数量]]<>\"\",InvoiceItems[[#This Row],[单价]]<>\"\"),(InvoiceItems[[#This Row],[数量]]*InvoiceItems[[#This Row],[单价]])-InvoiceItems[[#This Row],[折扣]],\"\")","v":""}]
[{"$nulls":6},"发票小计",{"$f":"SUM(InvoiceItems[总计])","v":{"v":38,"d":"¥38.00"}}]
[{"$nulls":6},"税率",{"v":0.089,"d":"9%"}]
[{"$nulls":6},"销售税",{"$f":"InvoiceSubtotal*SalesTaxRate","v":{"v":3.3819999999999997,"d":"¥3.38"}}]
[{"$nulls":6},"运费",{"v":5,"d":"¥5.00"}]
[null,{"$f":"\"所有支票支付给 \"&UPPER(公司名称)&\".\"","v":"所有支票支付给 TAILSPIN TOYS."},{"$nulls":4},"预收款",{"v":0,"d":"¥0.00"}]
[null,"应付款总额期限为 10 天。逾期账款每月收取 2% 的利息。",{"$nulls":4},"总计",{"$f":"InvoiceSubtotal+销售税+运费-存款","v":{"v":46.382,"d":"¥46.38"}}]

{"sheet":"客户","index":1,"n_rows":4,"n_cols":13,"rows_kept":4}
[null,"客户",{"$nulls":10},"商业发票"]
[null,"公司名称","联系信息","地址","地址 2","城市","州","邮政编码","电话","电子邮件","传真"]
[null,"Lilli Allik","Mike Gragg","345 Cherry Street","Suite 123","奥尔巴尼","SD",12345,"432-555-0178","mike@excellentwebsite.com","432-555-0187"]
[null,"Contoso, Ltd","Janine Mendoza","567 Walnut Lane",null,"莫林","MO","09876","432-555-0189","contoso@websitegoeshere.com","432-555-0123"]