User inputs file over existing excel file

I need to write a code that prompts the user to input an excel sheet which will replace a certain section of an already existing excel file. So, for example I have a file that's 20x100, with various values, and I need the user to input a 20x40 file which will replace 30-70 of the pre-existing file.

Any thoughts on how to do this?

Thanks.

Answer 1

[Siddharth Bhutiya]

You could use a function like "uigetfile" to have the user select a file from the PC. After this you can use "readtable" to read the file into MATLAB. Once you have the data in MATLAB, use the "writetable" function to write the data to an existing file. You would have to specify the "Range" property to write to a specific cell range in the file.

uigetfile: https://www.mathworks.com/help/matlab/ref/uigetdir.html

readtable: https://www.mathworks.com/help/matlab/ref/readtable.html

writetable: https://www.mathworks.com/help/matlab/ref/writetable.html

Range in writetable: https://www.mathworks.com/help/matlab/ref/writetable.html?s_tid=doc_ta#btyc9ne-1_sep_btyc9ne-1-Range