{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ячейки","товар"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"ячейки","index":0,"n_rows":200,"n_cols":8,"rows_kept":200,"cut":false,"hidden":false,"merged":[[0,7,12,19]]}
["Тип ячейки","Мин.ширина товара, мм","Макс.ширина товара, мм","Мин.высота товара, мм","Макс.высота товара, мм","Сюда необходимо перенести название товара",null,"Цыкл должен брать с листа \"товар\" сначала первую строку и сравнивать ее по ширине и высоте на соответствие критериев на листе \"ячейки\" начиная с первой по списку позиции и до последней. Если совпадение находит, то в столбец F строки с подходящими критериями ставится название товара. Далее берется следующий товар и сравнивается с самого начала по всему списку. И если совпадение находит, но в этой строке столбец F уже заполнен, то эту строку нужно пропустить и проверять следующую строку в листе \"ячейки\".. Таким образом макрос должен пройти по  каждому товару и  куда-то определить его, если совпадут размеры. "]
["A1",24,32,8,26,null,""]
["A1",24,32,8,26,null,""]
["A1",24,32,8,26,null,""]
["A1",24,32,8,26,null,"Товар4"]
["G1",36,44,8,26,null,"Товар5"]
["B1",39,47,8,26,null,""]
["B1",39,47,8,26,null,""]
["B1",39,47,8,26,null,""]
["B1",39,47,8,26,null,""]
["V1",53,61,8,26,null,""]
["V1",53,61,8,26,null,""]
["V1",53,61,8,26,null,""]
["V1",53,61,8,26,null,""]
["V1",53,61,8,26,null,""]
["V1",53,61,8,26,null,""]
["A2",24,32,8,37,null,"Товар16"]
["A2",24,32,8,37,null,"Товар17"]
["A2",24,32,8,37,null,"Товар18"]
["A2",24,32,8,37,null,"Товар19"]
["D2",24,32,8,37,null,"Товар20"]
["B2",39,47,8,37,null,""]
["V2",53,61,8,37,null,""]
["G5",36,44,8,45,null,"Товар23"]
["B4",39,47,8,49,null,""]
["B4",39,47,8,49,null,"Товар25"]
["V4",53,61,8,49,null,""]
["E4",53,61,8,49,null,""]
["B3",39,47,8,66,null,"Товар28"]
["B3",39,47,8,66,null,""]
["V3",53,61,8,66,null,""]
["A1",24,32,8,26,null,"Товар31"]
["A1",24,32,8,26,null,"Товар32"]
["A1",24,32,8,26,null,""]
["A1",24,32,8,26,null,""]
["G1",39,47,8,26,null,""]
["B1",44,52,8,26,null,"Товар36"]
["B1",44,52,8,26,null,"Товар37"]
["B1",44,52,8,26,null,""]
["B1",44,52,8,26,null,""]
["V1",56,64,8,26,null,""]
["V1",56,64,8,26,null,""]
["V1",56,64,8,26,null,""]
["V1",56,64,8,26,null,""]
["V1",56,64,8,26,null,""]
["V1",56,64,8,26,null,""]
["A2",24,32,8,37,null,"Товар46"]
["A2",24,32,8,37,null,"Товар47"]
["A2",24,32,8,37,null,""]
["A2",24,32,8,37,null,"Товар49"]
["D2",24,32,8,37,null,"Товар50"]
["B2",44,52,8,37,null,"Товар51"]
["V2",56,64,8,37,null,""]
["G5",39,47,8,45,null,"Товар53"]
["B4",44,52,8,49,null,"Товар54"]
["B4",44,52,8,49,null,"Товар55"]
["V4",56,64,8,49,null,"Товар56"]
["E4",56,64,8,49,null,"Товар57"]
["B3",44,52,8,66,null,"Товар58"]
["B3",44,52,8,66,null,""]
["V3",56,64,8,66,null,"Товар60"]
["A1",24,32,8,26,null,""]
["A1",24,32,8,26,null,""]
["A1",24,32,8,26,null,""]
["A1",24,32,8,26,null,"Товар64"]
["G1",37,45,8,26,null,""]
["B1",44,52,8,26,null,"Товар66"]
["B1",44,52,8,26,null,""]
["B1",44,52,8,26,null,""]
["B1",44,52,8,26,null,""]
["V1",56,64,8,26,null,""]
["V1",56,64,8,26,null,"Товар71"]
["V1",56,64,8,26,null,""]
["V1",56,64,8,26,null,"Товар73"]
["V1",56,64,8,26,null,"Товар74"]
["V1",56,64,8,26,null,""]
["A2",24,32,8,37,null,"Товар76"]
["A2",24,32,8,37,null,""]
["A2",24,32,8,37,null,"Товар78"]
["A2",24,32,8,37,null,""]
["D2",24,32,8,37,null,"Товар80"]
["B2",44,52,8,37,null,"Товар81"]
["V2",56,64,8,37,null,""]
["G5",37,45,8,45,null,"Товар83"]
["B4",44,52,8,49,null,"Товар84"]
["B4",44,52,8,49,null,"Товар85"]
["V4",56,64,8,49,null,""]
["E4",56,64,8,49,null,""]
["B3",44,52,8,66,null,"Товар88"]
["B3",44,52,8,66,null,""]
["V3",56,64,8,66,null,"Товар90"]
["A1",24,32,8,26,null,"Товар91"]
["A1",24,32,8,26,null,""]
["A1",24,32,8,26,null,""]
["A1",24,32,8,26,null,""]
["G1",37,45,8,26,null,"Товар95"]
["B1",44,52,8,26,null,""]
["B1",44,52,8,26,null,"Товар97"]
["B1",44,52,8,26,null,""]
["B1",44,52,8,26,null,""]
["V1",66,74,8,25,null,""]
["V1",66,74,8,25,null,""]
["V1",66,74,8,25,null,"Товар102"]
["V1",66,74,8,25,null,""]
["V1",66,74,8,25,null,""]
["V1",66,74,8,25,null,""]
["A2",24,32,8,37,null,"Товар106"]
["A2",24,32,8,37,null,""]
["A2",24,32,8,37,null,"Товар108"]
["A2",24,32,8,37,null,""]
["D2",24,32,8,37,null,"Товар110"]
["B2",44,52,8,37,null,"Товар111"]
["V2",66,74,8,36,null,""]
["G5",37,45,8,45,null,""]
["B4",44,52,8,49,null,""]
["B4",44,52,8,49,null,"Товар115"]
["V4",66,74,8,48,null,""]
["E4",66,74,8,48,null,""]
["B3",44,52,8,66,null,"Товар118"]
["B3",44,52,8,66,null,""]
["V3",66,74,8,65,null,"Товар120"]
["A1",24,32,8,26,null,""]
["A1",24,32,8,26,null,""]
["A1",24,32,8,26,null,"Товар123"]
["A1",24,32,8,26,null,"Товар124"]
["G1",37,45,8,26,null,""]
["B1",53,61,8,26,null,"Товар126"]
["B1",53,61,8,26,null,"Товар127"]
["B1",53,61,8,26,null,""]
["B1",53,61,8,26,null,""]
["V1",69,77,8,25,null,""]
["V1",69,77,8,25,null,""]
["V1",69,77,8,25,null,""]
["V1",69,77,8,25,null,"Товар133"]
["V1",69,77,8,25,null,"Товар134"]
["V1",69,77,8,25,null,""]
["A2",24,32,8,37,null,"Товар136"]
["A2",24,32,8,37,null,"Товар137"]
["A2",24,32,8,37,null,"Товар138"]
["A2",24,32,8,37,null,""]
["D2",24,32,8,37,null,"Товар140"]
["B2",53,61,8,37,null,""]
["V2",69,77,8,36,null,"Товар142"]
["G5",37,45,8,45,null,"Товар143"]
["B4",53,61,8,49,null,"Товар144"]
["B4",53,61,8,49,null,""]
["V4",69,77,8,48,null,"Товар146"]
["E4",69,77,8,48,null,""]
["B3",53,61,8,66,null,"Товар148"]
["B3",53,61,8,66,null,"Товар149"]
["V3",69,77,8,65,null,""]
["A1",24,32,8,26,null,"Товар151"]
["A1",24,32,8,26,null,"Товар152"]
["A1",24,32,8,26,null,""]
["A1",24,32,8,26,null,""]
["G1",39,47,8,26,null,""]
["B1",56,64,8,26,null,""]
["B1",56,64,8,26,null,"Товар157"]
["B1",56,64,8,26,null,""]
["B1",56,64,8,26,null,"Товар159"]
["V1",56,64,8,26,null,""]
["V1",56,64,8,26,null,""]
["V1",56,64,8,26,null,""]
["V1",56,64,8,26,null,"Товар163"]
["V1",56,64,8,26,null,""]
["V1",56,64,8,26,null,""]
["A2",24,32,8,37,null,"Товар166"]
["A2",24,32,8,37,null,""]
["A2",24,32,8,37,null,"Товар168"]
["A2",24,32,8,37,null,"Товар169"]
["D2",24,32,8,37,null,"Товар170"]
["B2",56,64,8,37,null,""]
["V2",56,64,8,37,null,"Товар172"]
["G5",39,47,8,45,null,""]
["B4",56,64,8,49,null,""]
["B4",56,64,8,49,null,""]
["V4",56,64,8,49,null,""]
["E4",80,88,8,46,null,""]
["B3",56,64,8,66,null,""]
["B3",56,64,8,66,null,""]
["V3",56,64,8,66,null,""]
["A1",24,32,8,26,null,""]
["A1",24,32,8,26,null,""]
["A1",24,32,8,26,null,""]
["A1",24,32,8,26,null,""]
["G1",35,43,8,26,null,""]
["B1",44,52,8,26,null,""]
["B1",44,52,8,26,null,""]
["B1",44,52,8,26,null,""]
["B1",44,52,8,26,null,""]
["V1",56,64,8,26,null,""]
["V1",56,64,8,26,null,""]
["V1",56,64,8,26,null,""]
["V1",56,64,8,26,null,""]
["V1",56,64,8,26,null,""]
["V1",56,64,8,26,null,""]
["A2",24,32,8,37,null,""]
["A2",24,32,8,37,null,""]
["A2",24,32,8,37,null,""]
["A2",24,32,8,37,null,""]

{"sheet":"товар","index":1,"n_rows":173,"n_cols":3,"rows_kept":173,"cut":false,"hidden":false,"merged":[]}
["Наименование","Ширина,мм","Высота,мм"]
["Товар1 ",55,55]
["Товар2",50,35]
["Товар3",40,40]
["Товар4",36,26]
["Товар5",80,20]
["Товар6",43,40]
["Товар7",33,33]
["Товар8",36,36]
["Товар9",36,26]
["Товар10",46,16]
["Товар11",34,26]
["Товар12",32,26]
["Товар13",45,17]
["Товар14",40,28]
["Товар15",90,50]
["Товар16",61,23]
["Товар17",31,30]
["Товар18",85,19]
["Товар19",50,35]
["Товар20",33,32]
["Товар21",37,37]
["Товар22",47,18]
["Товар23",41,20]
["Товар24",68,56]
["Товар25",85,23]
["Товар26",48,47]
["Товар27",40,48]
["Товар28",50,40]
["Товар29",37,20]
["Товар30",46,18]
["Товар31",62,20]
["Товар32",47,20]
["Товар33",38,40]
["Товар34",50,40]
["Товар35",85,40]
["Товар36",55,20]
["Товар37",60,22]
["Товар38",35,30]
["Товар39",36,35]
["Товар40",51,29]
["Товар41",40,17]
["Товар42",47,26]
["Товар43",55,30]
["Товар44",52,20]
["Товар45",40,30]
["Товар46",67,30]
["Товар47",35,35]
["Товар48",55,42]
["Товар49",71,12]
["Товар50",36,20]
["Товар51",44,16]
["Товар52",32,32]
["Товар53",80,32]
["Товар54",65,11]
["Товар55",45,40]
["Товар56",65,20]
["Товар57",65,16]
["Товар58",46,45]
["Товар59",40,20]
["Товар60",65,30]
["Товар61",51,30]
["Товар62",56,40]
["Товар63",48,34]
["Товар64",47,15]
["Товар65",78,32]
["Товар66",44,18]
["Товар67",43,30]
["Товар68",41,13]
["Товар69",42,15]
["Товар70",40,40]
["Товар71",88,20]
["Товар72",41,20]
["Товар73",65,26]
["Товар74",65,23]
["Товар75",45,45]
["Товар76",89,20]
["Товар77",65,42]
["Товар78",45,27]
["Товар79",68,40]
["Товар80",46,17]
["Товар81",65,20]
["Товар82",55,50]
["Товар83",49,26]
["Товар84",46,18]
["Товар85",55,20]
["Товар86",30,30]
["Товар87",40,30]
["Товар88",46,18]
["Товар89",40,40]
["Товар90",80,25]
["Товар91",65,16]
["Товар92",33,32]
["Товар93",78,31]
["Товар94",49,30]
["Товар95",40,20]
["Товар96",30,32]
["Товар97",47,18]
["Товар98",35,30]
["Товар99",90,50]
["Товар100",50,20]
["Товар101",57,20]
["Товар102",66,24]
["Товар103",34,16]
["Товар104",36,29]
["Товар105",32,32]
["Товар106",51,24]
["Товар107",52,51]
["Товар108",37,37]
["Товар109",60,47]
["Товар110",47,16]
["Товар111",65,18]
["Товар112",56,37]
["Товар113",35,30]
["Товар114",32,26]
["Товар115",84,37]
["Товар116",50,40]
["Товар117",50,20]
["Товар118",44,16]
["Товар119",40,40]
["Товар120",78,21]
["Товар121",37,37]
["Товар122",90,40]
["Товар123",40,16]
["Товар124",72,15]
["Товар125",65,30]
["Товар126",54,23]
["Товар127",78,20]
["Товар128",75,28]
["Товар129",52,18]
["Товар130",55,55]
["Товар131",35,30]
["Товар132",67,15]
["Товар133",75,25]
["Товар134",74,18]
["Товар135",62,24]
["Товар136",80,24]
["Товар137",44,18]
["Товар138",48,25]
["Товар139",90,50]
["Товар140",35,30]
["Товар141",34,34]
["Товар142",69,20]
["Товар143",80,13]
["Товар144",65,11]
["Товар145",50,18]
["Товар146",70,46]
["Товар147",65,30]
["Товар148",80,17]
["Товар149",70,30]
["Товар150",45,27]
["Товар151",80,22]
["Товар152",39,20]
["Товар153",35,30]
["Товар154",40,40]
["Товар155",80,32]
["Товар156",40,28]
["Товар157",81,20]
["Товар158",40,32]
["Товар159",63,26]
["Товар160",47,47]
["Товар161",45,20]
["Товар162",31,30]
["Товар163",62,20]
["Товар164",30,30]
["Товар165",37,37]
["Товар166",77,20]
["Товар167",57,57]
["Товар168",81,36]
["Товар169",41,18]
["Товар170",40,22]
["Товар171",45,18]
["Товар172",75,35]