Hi,
You can use "xlsread" for MATLAB versions before R2019a and "readmatrix" for versions starting R2019a as "xlsread" is not recommended starting R2019a.
Here is an example snippet for your reference:
inFile = 'input_example.xlsx';
inSheet = 'RawData';
M = [0.5 -1 ; 1.2 0.3 ; 0 0.8];
A = readmatrix(inFile, 'Sheet', inSheet);
R = A * M;
writematrix(R, inFile, 'Sheet', 'Results', 'Range', 'A1');
Here is more info on "readmatrix" and "xlsread" :
- https://www.mathworks.com/help/matlab/ref/xlsread.html?s_tid=srchtitle_support_results_1_xlsread
- https://www.mathworks.com/help/matlab/ref/readmatrix.html?s_tid=srchtitle_support_results_1_readmatrix
Hope this helps!
