{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Product","Customer","Invoice"],"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":"Product","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Product List"]
[]
[null,"HSN Code","Product Name","Unit Price"]
[null,501,"Monitor",120]
[null,502,"Keyboard",15]
[null,503,"Mouse",15]
[null,504,"SSD",60]
[null,506,"RAM",40]

{"sheet":"Customer","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Customer List"]
[]
[null,"Customer ID","Company Name","Address","Contact No"]
[null,"RC.1.1","X","Windsor","+14378863164"]
[null,"RC.1.2","Y","Toronto","+14378861224"]
[null,"RC.1.3","Z","Kingston","+14378863136"]
[null,"RC.1.4","A","Thunder Bay","+14378862847"]
[null,"RC.1.5","B","Ottawa","+14378863124"]

{"sheet":"Invoice","index":2,"n_rows":26,"n_cols":21,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,1,25,6],[7,3,7,6],[1,1,1,6],[17,1,17,6],[18,1,18,2],[19,1,19,2],[20,1,20,2],[18,3,18,6],[19,3,19,6],[20,3,20,6],[4,1,4,2],[4,3,4,6],[5,3,5,6],[6,3,6,6],[3,3,3,4],[3,5,3,6],[2,1,2,6],[22,1,23,6],[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[8,4,8,6],[21,1,21,6]]}
[]
[null,"ABC Computers & Technology"]
[null,"INVOICE "]
[null,"Invoice No",1,"Date",null,{"$f":"TODAY()","v":"2022-08-22"}]
[null,"SHIP TO",null,"Bill From"]
[null,{"$f":"IFERROR(VLOOKUP($C$9,Customer!$B$4:$E$9,2,FALSE),\"\")","v":""},null,{"$f":"B2","v":"ABC Computers & Technology"}]
[null,{"$f":"IFERROR(VLOOKUP($C$9,Customer!$B$4:$E$9,3,FALSE),\"\")","v":""},null,"Ottawa, Ontario"]
[null,{"$f":"IFERROR(VLOOKUP($C$9,Customer!$B$4:$E$9,4,FALSE),\"\")","v":""},null,"Contect Number: +14378862659"]
[null,"ID",null,"TIN",978731657]
[]
[null,"Serial","HSN Code","Product","Qty","Unit Price","Amount"]
[]
[null,1,null,{"$f":"IFERROR(VLOOKUP(C13,Product!$B$4:$D$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C13,Product!$B$4:$D$9,3,FALSE),\"\")","v":""},{"$f":"IFERROR(E13*F13,\"\")","v":""}]
[null,2,null,{"$f":"IFERROR(VLOOKUP(C14,Product!$B$4:$D$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C14,Product!$B$4:$D$9,3,FALSE),\"\")","v":""},{"$f":"IFERROR(E14*F14,\"\")","v":""}]
[null,3,null,{"$f":"IFERROR(VLOOKUP(C15,Product!$B$4:$D$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C15,Product!$B$4:$D$9,3,FALSE),\"\")","v":""},""]
[null,4,null,{"$f":"IFERROR(VLOOKUP(C16,Product!$B$4:$D$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C16,Product!$B$4:$D$9,3,FALSE),\"\")","v":""},""]
[null,5,null,{"$f":"IFERROR(VLOOKUP(C17,Product!$B$4:$D$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(C17,Product!$B$4:$D$9,3,FALSE),\"\")","v":""},""]
[null,"Total Amount"]
[null,"Amount",null,{"$f":"SUM(G13:G17)","v":0}]
[null,"VAT (@7.5%)",null,{"$f":"D19*7.5%","v":0}]
[null,"Total Amount",null,{"$f":"D19+D20","v":0}]
[]
[null,"Sign…......................................"]
[]
[null,"Terms & Conditions:-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"l"]