{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sample","Sheet1","Лист2","Лист3"],"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":"Sample","index":0,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Старый прайс",null,null,null,null,null,null,"Обновление прайса"]
["num","stk","prc",null,null,null,null,"num","stk","prc"]
["А_5821V",3,2519,null,null,null,null,"А_5821V",3,2770,null,null,"От поставщика приходит прайс лист с остатками каждую неделю, так вот проблема заключается в том что они нулевые позиции просто в него не включают."]
["А_05AXFS",2,2518,null,null,null,null,"А_05AXFS",1,2770,null,null,"Хотелось бы иметь макрос:"]
["A_6111F",1,803,null,null,null,null,"A_6111F",1,880]
["А_6282",2,3875,null,null,null,null,"А_6282",1,4260,null,null,"-который сверял бы артикулы и заменял на совпадающих артикулах цену и остаток"]
["А_6349",4,3875,null,null,null,null,"А_6349",2,4260,null,null,"-а на отсутствующих артикулах в старом прайсе ставил бы остаток 0"]
["А_6372",1,6200,null,null,null,null,"А_6372",1,6820,null,null,"-а если в обновленном прайсе появились новые позиции, по сравнению со старым, выделял бы их зеленым "]
["A_6382",2,3875,null,null,null,null,"A_6382",2,4260]
["A_2004N0",4,4092,null,null,null,null,"A_2004N0",3,4500]
["A_6392",7,3500,null,null,null,null,"A_6392",5,3850]
["А_6328",2,3500,null,null,null,null,"А_6328",2,3850]
["А_6354",4,3500,null,null,null,null,"А_6354",4,3850]
["А_6334",1,1164,null,null,null,null,"А_6334",1,1280]
["A_15SON025",8,572,null,null,null,null,"A_15SON025",4,630]
["A_5826F",2,572,null,null,null,null,"A_5826F",2,630]
["A_6154",2,1067,null,null,null,null,"A_6154",2,1170]
["A_15PRN027",2,572,null,null,null,null,"AI0311316FFS_S",1,4778]
["A_15SON026",1,572,null,null,null,null,"AI0311316FFS_XS",1,4778]
["A_15SON018",3,572,null,null,null,null,"AI0311316FSS_S",2,4778]
["A_1220N",1,572,null,null,null,null,"AI0311316FSS_XS",1,4778]

{"sheet":"Sheet1","index":1,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Старый прайс",null,null,null,null,null,null,"Обновление прайса"]
["num","остаток","цена",null,null,null,null,"num","остаток","цена"]
["А_5821V",654,2770,null,null,null,null,"А_5821V",654,2770,null,null,"От поставщика приходит прайс лист с остатками каждую неделю, так вот проблема заключается в том что они нулевые позиции просто в него не включают."]
["А_05AXFS",1,156,null,null,null,null,"А_05AXFS",1,156,null,null,"Хотелось бы иметь макрос:"]
["A_6111F",1,880,null,null,null,null,"A_6111F",1,880]
["А_6282",1,4260,null,null,null,null,"А_6282",1,4260,null,null," -который сверял бы артикулы и заменял на совпадающих артикулах цену и остаток"]
["А_6349",2,4260,null,null,null,null,"А_6349",2,4260,null,null," -а на отсутствующих артикулах в старом прайсе ставил бы остаток 0"]
["А_6372",1,6820,null,null,null,null,"А_6372",1,6820,null,null," -а если в обновленном прайсе появились новые позиции, по сравнению со старым, выделял бы их зеленым "]
["A_6382",2,4260,null,null,null,null,"A_6382",2,4260,null,null,"p.s. позиций в прайсе около 2500, краткий образец во вложении."]
["A_2004N0",3,4500,null,null,null,null,"A_2004N0",3,4500]
["A_6392",5,3850,null,null,null,null,"A_6392",5,3850]
["А_6328",2,3850,null,null,null,null,"А_6328",2,3850]
["А_6354",4,3850,null,null,null,null,"А_6354",4,3850]
["А_6334",1,1280,null,null,null,null,"А_6334",1,1280]
["A_15SON025",4,630,null,null,null,null,"A_15SON025",4,630]
["A_5826F",2,630,null,null,null,null,"A_5826F",2,630]
["A_6154",2,1170,null,null,null,null,"A_6154",2,1170]
["A_15PRN027",88,1,null,null,null,null,"AI0311316FFS_S",1,4778]
["A_15SON026",77,2,null,null,null,null,"AI0311316FFS_XS",1,4778]
["A_15SON018",99,3,null,null,null,null,"AI0311316FSS_S",2,4778]
["A_1220N",66,4,null,null,null,null,"AI0311316FSS_XS",1,4778]

{"sheet":"Лист2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}