How to copy a range of values from an one excel file to another

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.

This topic was automatically closed 90 days after the last reply. We invite you to open a new topic if you have further questions or comments.