I am using umya_spreadsheets to manipulate excel files.
I have multiple smaller excel files and I am going to write data of all the excel files to one large excel file.
I wanted to read range of values of of smaller files one by one and than copy that data to one large excel file. There is a function get_cell_value_by_range() to read data of a range of values as follows:
let book1_vec = book1.get_sheet(&0).unwrap().get_cell_value_by_range("A1:J5");
how can I copy the whole range to the combine sheet at once. Like I wanted to write book1_vec to the combine file directly without going through all the cells one by one.