{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["销售收据"],"read":"whole","date_system":"1900"}

{"sheet":"销售收据","index":0,"n_rows":29,"n_cols":7,"rows_kept":29,"merged":[[0,1,1,3],[0,5,1,6],[8,1,8,2],[9,1,9,2],[25,1,25,3],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[33,1,33,3]]}
[null,"MODERN DESIGN CO.",{"$nulls":3},"销售收据"]
[]
[null,"现代艺术家的精美解决方案"]
[null,"受票方",null,"发票编号","日期"]
[null,"Saara Teinemaa",null,"XYZ123","01/01/XX"]
[null,"公司",null,"地址","电话"]
[null,"Create & Co.",null,"321 Sycamore","(415) 555-0123"]
[{"$nulls":3},"Albany, NY 12345","(415) 555-0124"]
[null,"支付方式",null,"支票编号","职务"]
[null,"电汇",null,987654,"设计工作室拍摄"]
[]
[null,"数量","产品编号","说明","单价","折扣","行合计"]
[null,3,"不适用","照片拍摄（小时）",{"v":100,"d":"¥100.00"},{"v":0.1,"d":"10%"},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":{"v":270,"d":"¥270.00"}}]
[null,1,100,"照片的拇指驱动器",{"v":45,"d":"¥45.00"},null,{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":{"v":45,"d":"¥45.00"}}]
[null,2.5,"不适用","编辑（小时）",{"v":35,"d":"¥35.00"},null,{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":{"v":87.5,"d":"¥87.50"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":6},{"$f":"IFERROR(IF(OR(Table_SalesReceiptDetails[[#This Row],[数量]]=\"\",Table_SalesReceiptDetails[[#This Row],[单价]]=\"\"),\"\",Table_SalesReceiptDetails[[#This Row],[数量]]*(1-Table_SalesReceiptDetails[[#This Row],[折扣]])*Table_SalesReceiptDetails[[#This Row],[单价]]),\"\")","v":""}]
[]
[null,"如对此发票有疑问，请使用以下联系人信息：",null,null,"总折扣"]
[null,"Nathan Rigby | (123) 456-7890 | nathan@example.com",null,null,"小计",null,{"$f":"SUM(Table_SalesReceiptDetails[行合计])","v":{"v":402.5,"d":"¥402.50"}}]
[{"$nulls":4},"销售税",null,{"v":0.06,"d":"6.00%"}]
[null,"谢谢惠顾！",null,null,"总计",null,{"$f":"(G27-(G27*G26))*(1+G28)","v":{"v":426.65000000000003,"d":"¥426.65"}}]