{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Hľadanie1","Hľadanie2","Produkty"],"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":"Hľadanie1","index":0,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Produkt EAV/IntID","Pozícia","Produkt","Balenie","Cena","Popis"]
[12345,{"$f":"IF(ISERROR(MATCH(A2,tblProdukty[EAN],0)),IFERROR(MATCH(A2,tblProdukty[IntID],0),\"\"),MATCH(A2,tblProdukty[EAN],0))","v":5},{"$f":"IF($B2=\"\",\"\",INDEX(tblProdukty[Produkt],$B2))","v":"varecha"},{"$f":"IF($B2=\"\",\"\",INDEX(tblProdukty[Balenie],$B2))","v":"1ks"},{"$f":"IF($B2=\"\",\"\",INDEX(tblProdukty[Cena],$B2))","v":55},{"$f":"IF($B2=\"\",\"\",INDEX(tblProdukty[Popis],$B2))","v":"g ddgh dhh"}]
[2345,{"$f":"IF(ISERROR(MATCH(A3,tblProdukty[EAN],0)),IFERROR(MATCH(A3,tblProdukty[IntID],0),\"\"),MATCH(A3,tblProdukty[EAN],0))","v":2},{"$f":"IF($B3=\"\",\"\",INDEX(tblProdukty[Produkt],$B3))","v":"Cukor"},{"$f":"IF($B3=\"\",\"\",INDEX(tblProdukty[Balenie],$B3))","v":"1kg"},{"$f":"IF($B3=\"\",\"\",INDEX(tblProdukty[Cena],$B3))","v":22},{"$f":"IF($B3=\"\",\"\",INDEX(tblProdukty[Popis],$B3))","v":"ghfh"}]
["eafds",{"$f":"IF(ISERROR(MATCH(A4,tblProdukty[EAN],0)),IFERROR(MATCH(A4,tblProdukty[IntID],0),\"\"),MATCH(A4,tblProdukty[EAN],0))","v":3},{"$f":"IF($B4=\"\",\"\",INDEX(tblProdukty[Produkt],$B4))","v":"Soľ"},{"$f":"IF($B4=\"\",\"\",INDEX(tblProdukty[Balenie],$B4))","v":"1kg"},{"$f":"IF($B4=\"\",\"\",INDEX(tblProdukty[Cena],$B4))","v":33},{"$f":"IF($B4=\"\",\"\",INDEX(tblProdukty[Popis],$B4))","v":"ghgfhgfh"}]
[6,{"$f":"IF(ISERROR(MATCH(A5,tblProdukty[EAN],0)),IFERROR(MATCH(A5,tblProdukty[IntID],0),\"\"),MATCH(A5,tblProdukty[EAN],0))","v":5},{"$f":"IF($B5=\"\",\"\",INDEX(tblProdukty[Produkt],$B5))","v":"varecha"},{"$f":"IF($B5=\"\",\"\",INDEX(tblProdukty[Balenie],$B5))","v":"1ks"},{"$f":"IF($B5=\"\",\"\",INDEX(tblProdukty[Cena],$B5))","v":55},{"$f":"IF($B5=\"\",\"\",INDEX(tblProdukty[Popis],$B5))","v":"g ddgh dhh"}]
[null,{"$f":"IF(ISERROR(MATCH(A6,tblProdukty[EAN],0)),IFERROR(MATCH(A6,tblProdukty[IntID],0),\"\"),MATCH(A6,tblProdukty[EAN],0))","v":""},{"$f":"IF($B6=\"\",\"\",INDEX(tblProdukty[Produkt],$B6))","v":""},{"$f":"IF($B6=\"\",\"\",INDEX(tblProdukty[Balenie],$B6))","v":""},{"$f":"IF($B6=\"\",\"\",INDEX(tblProdukty[Cena],$B6))","v":""},{"$f":"IF($B6=\"\",\"\",INDEX(tblProdukty[Popis],$B6))","v":""}]
[null,{"$f":"IF(ISERROR(MATCH(A7,tblProdukty[EAN],0)),IFERROR(MATCH(A7,tblProdukty[IntID],0),\"\"),MATCH(A7,tblProdukty[EAN],0))","v":""},{"$f":"IF($B7=\"\",\"\",INDEX(tblProdukty[Produkt],$B7))","v":""},{"$f":"IF($B7=\"\",\"\",INDEX(tblProdukty[Balenie],$B7))","v":""},{"$f":"IF($B7=\"\",\"\",INDEX(tblProdukty[Cena],$B7))","v":""},{"$f":"IF($B7=\"\",\"\",INDEX(tblProdukty[Popis],$B7))","v":""}]

{"sheet":"Hľadanie2","index":1,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Produkt EAV","Produkt IntID","Produkt","Balenie","Cena","Popis"]
[12345,6,"varecha","1ks",55,"g ddgh dhh"]
["A5462",2345,"Cukor","1kg",22,"ghfh"]
["123ABC",12345,"Múka","1kg",11,"ghfg"]
[null,null,{"$f":"IF($B5=\"\",\"\",INDEX(tblProdukty[Produkt],$B5))","v":""},{"$f":"IF($B5=\"\",\"\",INDEX(tblProdukty[Balenie],$B5))","v":""},{"$f":"IF($B5=\"\",\"\",INDEX(tblProdukty[Cena],$B5))","v":""},{"$f":"IF($B5=\"\",\"\",INDEX(tblProdukty[Popis],$B5))","v":""}]
[null,null,{"$f":"IF($B6=\"\",\"\",INDEX(tblProdukty[Produkt],$B6))","v":""},{"$f":"IF($B6=\"\",\"\",INDEX(tblProdukty[Balenie],$B6))","v":""},{"$f":"IF($B6=\"\",\"\",INDEX(tblProdukty[Cena],$B6))","v":""},{"$f":"IF($B6=\"\",\"\",INDEX(tblProdukty[Popis],$B6))","v":""}]
[null,null,{"$f":"IF($B7=\"\",\"\",INDEX(tblProdukty[Produkt],$B7))","v":""},{"$f":"IF($B7=\"\",\"\",INDEX(tblProdukty[Balenie],$B7))","v":""},{"$f":"IF($B7=\"\",\"\",INDEX(tblProdukty[Cena],$B7))","v":""},{"$f":"IF($B7=\"\",\"\",INDEX(tblProdukty[Popis],$B7))","v":""}]

{"sheet":"Produkty","index":2,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["EAN","IntID","Produkt","Balenie","Cena","Popis"]
["123ABC",12345,"Múka","1kg",11,"ghfg"]
["A5462",2345,"Cukor","1kg",22,"ghfh"]
["EAFDS",345,"Soľ","1kg",33,"ghgfhgfh"]
["SDGSG12",56,"Strúhanka","0,5kg",44,"dhgdfhg"]
[12345,6,"varecha","1ks",55,"g ddgh dhh"]