User inputs file over existing excel file

1 次查看（过去 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.
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

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by