User inputs file over existing excel file

조회 수: 2(최근 30일)
Anna Ruefer
Anna Ruefer 2019년 4월 4일
답변: Siddharth Bhutiya 2019년 4월 10일
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.

답변(1개)

Siddharth Bhutiya
Siddharth Bhutiya 2019년 4월 10일
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.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by