{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["UP_","Formuls"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":12,"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":"UP_","index":0,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[15]
[null,null,null,null,null,null,"В этот столбец надо вставить занчение ячейки (Formuls).Cells(5, 10), так чтоб формула  ВПР работала"]

{"sheet":"Formuls","index":1,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"LEFT(CELL(\"filename\"), FIND(\"[\",CELL(\"filename\"))-1)","v":"D:\\"}]
[]
[]
["Текущая дата",null,{"$f":"YEAR(TODAY())","v":2020},{"$f":"TEXT(MONTH(TODAY()),\"ДД\")","v":"01"},{"$f":"TEXT(DAY(TODAY()),\"ДД\")","v":"22"},null,{"$f":"\"Цена_на\"&\"_\"&C5&\"_\"&D5&\"_\"&E5","v":"Цена_на_2020_01_22"},null,null,{"$f":"\"=ВПР(RC1;'\"&$B$2&\"[\"&G5&\".xls]TDSheet'!С1:С8;5;0)\"","v":"=ВПР(RC1;'D:\\[Цена_на_2020_01_22.xls]TDSheet'!С1:С8;5;0)"}]
[]
[]
[null,null,null,null,null,null,null,null,null,"=ВПР(RC1;'D:\\[Цена_на_2020_01_22.xls]TDSheet'!С1:С8;5;0)"]