{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Заявка","Иванов","Петров","Сидоров"],"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":"Заявка","index":0,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Общая заявка"]
[null,"Наименов",null,"Иванов","Петров","Сидоров","Итого"]
[1,"Яблоки","кг",5,9,null,{"$f":"SUM(D3:F3)","v":14}]
[2,"Помидоры","кг",2,null,80,{"$f":"SUM(D4:F4)","v":82}]
[3,"Огурцы","кг",null,20,null,20]
[4,"Картофель","кг",null,null,40,40]
[5,"Огурцы","кг",null,12,null,12]
[6,"Огурцы","кг",6,null,15,21]
[]
[]
[]
[]
[null,"При корректир(вручную) общей заявки формула сбивается (лучше использовать макрос копирования с листов и вставки значений по своим колонкам)"]
[null,"Таблица очень большая для примера сделал 3 листа и 3 колонки в общей заявке"]

{"sheet":"Иванов","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Наименов","ед.изм","Кол-во"]
[1,"Яблоки","кг",5]
[2,"Помидоры","кг",2]
[3,"Огурцы","кг"]
[4,"Картофель","кг"]
[5,"Огурцы","кг"]
[6,"Огурцы","кг",6]

{"sheet":"Петров","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Наименов","ед.изм","Кол-во"]
[1,"Яблоки","кг",9]
[2,"Помидоры","кг"]
[3,"Огурцы","кг",20]
[4,"Картофель","кг"]
[5,"Огурцы","кг",12]
[6,"Огурцы","кг"]

{"sheet":"Сидоров","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Наименов","ед.изм","Кол-во"]
[1,"Яблоки","кг"]
[2,"Помидоры","кг",80]
[3,"Огурцы","кг"]
[4,"Картофель","кг",40]
[5,"Огурцы","кг"]
[6,"Огурцы","кг",15]