User inputs file over existing excel file
1 view (last 30 days)
Show older comments
Anna Ruefer on 4 Apr 2019
Answered: Siddharth Bhutiya on 10 Apr 2019
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?
Siddharth Bhutiya on 10 Apr 2019
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.
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!