{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист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":"Лист1","index":0,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,5,0,8],[13,5,20,8]]}
["Что есть",null,null,null,null,"Что хотелось бы"]
["ИД","Сумма",null,"Дата выставления счета",null,"ИД","Сумма",null,"Дата выставления счета"]
[100,1,"А","2016-11-30",null,100,1,"А","2016-11-01"]
[101,1,"А","2016-09-30",null,101,2,"А","Сентябрь 2016 - Октябрь 2016"]
[101,1,"А","2016-10-31",null,102,1,"А","2016-11-01"]
[102,1,"А","2016-09-30",null,103,1,"А","2016-11-01"]
[103,1,"А","2016-10-31",null,104,1,"А","2016-11-01"]
[104,1,"А","2016-11-30",null,105,2,"А","Сентябрь 2016 - Ноябрь 2016"]
[105,1,"A","2016-09-30",null,106,8,"А","Май 2016 - Ноябрь 2016"]
[105,1,"A","2016-10-31",null,106,1,"Б","2016-02-01"]
[105,1,"A","2016-11-30",null,107,12,"А","Сентябрь 2015 - Февраль 2016, Май 2016 - Октябрь 2016"]
[106,1,"А","2016-05-31"]
[106,1,"А","2016-06-28"]
[106,1,"А","2016-06-30",null,"Первичное условие ИД. Далее ищем все что относится к нему… Сама суть выявить даты идущие последовательно и вывести их в читабельном формате через дефис. Если есть разрыв последовательности ставим запятую и следующую последовательность через дефис."]
[106,1,"А","2016-07-31"]
[106,1,"А","2016-08-31"]
[106,1,"А","2016-09-30"]
[106,1,"А","2016-10-31"]
[106,1,"А","2016-11-30"]
[106,1,"Б","2016-02-01"]
[107,1,"А","2015-09-30"]
[107,1,"А","2015-10-31"]
[107,1,"А","2015-11-30"]
[107,1,"А","2015-12-31"]
[107,1,"А","2016-01-31"]
[107,1,"А","2016-02-29"]
[107,1,"А","2016-05-31"]
[107,1,"А","2016-06-30"]
[107,1,"А","2016-07-31"]
[107,1,"А","2016-08-31"]
[107,1,"А","2016-09-30"]
[107,1,"А","2016-10-31"]

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

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