{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист3","Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"Лист3","index":0,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["M","(Все)",null,"Выбрать",null,"04",null," -нужно чтобы в фильтре  сводной выбиралось то что стоит в ячейке F1 макросом, он написан, но есть ошибка."]
[]
["Сумма по полю VALUE","Названия столбцов"]
["Названия строк","01","02","03","04","05","06","07","08","09","10","Общий итог"]
["V1",1,null,null,null,null,null,null,null,null,null,1]
["V2",null,2,null,null,null,null,null,null,null,null,2]
["V3",null,null,3,null,null,null,null,null,null,null,3]
["V4",null,null,null,4,null,null,null,null,null,null,4]
["V5",null,null,null,null,5,null,null,null,null,null,5]
["V6",null,null,null,null,null,6,null,null,null,null,6]
["V7",null,null,null,null,null,null,7,null,null,null,7]
["V8",null,null,null,null,null,null,null,8,null,null,8]
["V9",null,null,null,null,null,null,null,null,9,null,9]
["V10",null,null,null,null,null,null,null,null,null,10,10]
["V11",11,null,null,null,null,null,null,null,null,null,11]
["V12",null,12,null,null,null,null,null,null,null,null,12]
["V13",null,null,13,null,null,null,null,null,null,null,13]
["V14",null,null,null,14,null,null,null,null,null,null,14]
["V15",null,null,null,null,15,null,null,null,null,null,15]
["V16",null,null,null,null,null,16,null,null,null,null,16]
["V17",null,null,null,null,null,null,17,null,null,null,17]
["V18",null,null,null,null,null,null,null,18,null,null,18]
["V19",null,null,null,null,null,null,null,null,19,null,19]
["V20",null,null,null,null,null,null,null,null,null,20,20]
["Общий итог",12,14,16,18,20,22,24,26,28,30,210]

{"sheet":"Лист1","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Y","M","D","SUPER_REGION_NAME","MARKET_NAME","STREAM","VALUE"]
["2021","03","01",null,"V1",null,1]
["2021","04","02",null,"V2",null,2]
["2021","05","03",null,"V3",null,3]
["2021","06","04",null,"V4",null,4]
["2021","07","05",null,"V5",null,5]
["2021","08","06",null,"V6",null,6]
["2021","09","07",null,"V7",null,7]
["2021","10","08",null,"V8",null,8]
["2021","11","09",null,"V9",null,9]
["2021","12","10",null,"V10",null,10]
["2022","03","01",null,"V11",null,11]
["2022","04","02",null,"V12",null,12]
["2022","05","03",null,"V13",null,13]
["2022","06","04",null,"V14",null,14]
["2022","07","05",null,"V15",null,15]
["2022","08","06",null,"V16",null,16]
["2022","09","07",null,"V17",null,17]
["2022","10","08",null,"V18",null,18]
["2022","11","09",null,"V19",null,19]
["2022","12","10",null,"V20",null,20]