{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Invoice","product","Customer"],"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":"Invoice","index":0,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[17,0,17,10],[25,0,26,10],[7,6,7,10],[8,7,8,10],[8,2,8,5],[7,0,7,4],[4,0,4,5],[4,6,4,10],[5,6,5,10],[6,6,6,10],[5,0,5,4],[6,0,6,4],[3,3,3,4],[3,9,3,10],[3,7,3,8],[3,5,3,6],[1,0,1,10],[2,0,2,10],[3,0,3,1],[22,0,22,6],[22,7,22,9],[23,0,23,1],[23,2,23,6],[23,7,24,10],[24,0,24,1],[24,2,24,6],[18,0,18,4],[19,0,19,4],[20,0,20,4],[21,0,21,4],[18,5,18,10],[19,5,19,10],[20,5,20,10],[21,5,21,10],[10,6,11,6],[10,7,10,8],[10,9,10,10],[10,2,11,2],[10,0,11,0],[10,1,11,1],[10,3,11,3],[10,4,11,4],[10,5,11,5]]}
[]
["\"N\" Fruit Supplier"]
["GST INVOICE "]
["Invoice No",null,2,"State Code",null,"ON",null,"Date",null,{"$f":"TODAY()","v":"2022-01-25"}]
["SHIP TO",null,null,null,null,null,"BILL FROM"]
[{"$f":"IFERROR(VLOOKUP($B$9,Customer!$B$5:$E$10,2,FALSE),\"\")","v":"Z "},null,null,null,null,null,"\"N\" Fruit Supplier"]
[{"$f":"IFERROR(VLOOKUP($B$9,Customer!$B$5:$E$10,3,FALSE),\"\")","v":"Kingston"},null,null,null,null,null,"Ottawa, Ontario"]
[{"$f":"IFERROR(VLOOKUP($B$9,Customer!$B$5:$E$10,4,FALSE),\"\")","v":"+14378863136"},null,null,null,null,null,"Contect Number: +14378862659"]
["GSTIN","ONFSDCXXXX5D1ZR",null,null,null,null,"GSTIN","ONAACXXXX5D1ET"]
[]
["Serial","HSN Code","Product","Qty","Unit Price","Amount","Taxable Amount","CGST",null,"SGST"]
[null,null,null,null,null,null,null,"Rate","Amount","Rate","Amount"]
[1,801,{"$f":"IFERROR(VLOOKUP(B13,product!B5:F9,2,FALSE),\"\")","v":"Coconut"},200,{"$f":"IFERROR(VLOOKUP(B13,product!B5:F9,3,FALSE),\"\")","v":5},{"$f":"D13*E13","v":1000},{"$f":"I13+K13","v":70},{"$f":"IFERROR(VLOOKUP(B13,product!B5:F9,4,FALSE),\"\")","v":0.03},{"$f":"F13*H13","v":30},{"$f":"IFERROR(VLOOKUP(B13,product!B5:F9,5,FALSE),\"\")","v":0.04},{"$f":"F13*J13","v":40}]
[2,810,{"$f":"IFERROR(VLOOKUP(B14,product!B6:F10,2,FALSE),\"\")","v":"Kiwi"},500,{"$f":"IFERROR(VLOOKUP(B14,product!B6:F10,3,FALSE),\"\")","v":3},{"$f":"D14*E14","v":1500},{"$f":"I14+K14","v":90},{"$f":"IFERROR(VLOOKUP(B14,product!B6:F10,4,FALSE),\"\")","v":0.02},{"$f":"F14*H14","v":30},{"$f":"IFERROR(VLOOKUP(B14,product!B6:F10,5,FALSE),\"\")","v":0.04},{"$f":"F14*J14","v":60}]
[3,807,{"$f":"IFERROR(VLOOKUP(B15,product!B7:F11,2,FALSE),\"\")","v":"Watermelon"},300,{"$f":"IFERROR(VLOOKUP(B15,product!B7:F11,3,FALSE),\"\")","v":7},2100,231,{"$f":"IFERROR(VLOOKUP(B15,product!B7:F11,4,FALSE),\"\")","v":0.05},105,{"$f":"IFERROR(VLOOKUP(B15,product!B7:F11,5,FALSE),\"\")","v":0.06},126]
[4,808,{"$f":"IFERROR(VLOOKUP(B16,product!B8:F12,2,FALSE),\"\")","v":"Apple"},798,{"$f":"IFERROR(VLOOKUP(B16,product!B8:F12,3,FALSE),\"\")","v":4},3192,255.36,{"$f":"IFERROR(VLOOKUP(B16,product!B8:F12,4,FALSE),\"\")","v":0.04},127.68,{"$f":"IFERROR(VLOOKUP(B16,product!B8:F12,5,FALSE),\"\")","v":0.04},127.68]
[5,809,{"$f":"IFERROR(VLOOKUP(B17,product!B9:F13,2,FALSE),\"\")","v":"Apricot"},570,{"$f":"IFERROR(VLOOKUP(B17,product!B9:F13,3,FALSE),\"\")","v":3},1710,188.1,{"$f":"IFERROR(VLOOKUP(B17,product!B9:F13,4,FALSE),\"\")","v":0.05},85.5,{"$f":"IFERROR(VLOOKUP(B17,product!B9:F13,5,FALSE),\"\")","v":0.06},102.6]
["Total Amount"]
["Amount",null,null,null,null,{"$f":"SUM(F13:F17)","v":9502}]
["CGST",null,null,null,null,{"$f":"SUM(I13:I17)","v":378.18}]
["SGST",null,null,null,null,{"$f":"SUM(K13:K17)","v":456.28}]
["Total Amount",null,null,null,null,{"$f":"SUM(F19:K21)","v":10336.460000000001}]
["Bank Details"]
["A/C Name",null,"Michael James",null,null,null,null,"Sign…......................................"]
[" A/C No.",null,"0034567"]
["Terms & Conditions:-"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"l"]

{"sheet":"product","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Product Details"]
[]
[null,"HSN Code","Product Name","Unit Price","CGST","SGST"]
[null,801,"Coconut",5,0.03,0.04]
[null,810,"Kiwi",3,0.02,0.04]
[null,807,"Watermelon",7,0.05,0.06]
[null,808,"Apple",4,0.04,0.04]
[null,809,"Apricot",3,0.05,0.06]

{"sheet":"Customer","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Company Details"]
[]
[null,"GSTIN","Company Name","Area","Contact No"]
[null,"ONAAACXXXX5D1Z4","X ","Windsor","+14378863164"]
[null,"ONXCACXXXX5D1ZY","Y ","Toronto","+14378861224"]
[null,"ONFSDCXXXX5D1ZR","Z ","Kingston","+14378863136"]
[null,"ONAAACXXXX5D1E5","A ","Thunder Bay","+14378862847"]
[null,"ONAAACXXXX5D169","B ","Ottawa","+14378863124"]
[null,"ONAAACXXXX5D1G6","C ","Sarnia","+14378862656"]