I'm trying to import a matrix from an excel file and then writing it back to the same excel file. I was able to read the matrix M just fine, but I'm not able to write to the excel file. What am I missing? Thanks.

%Path1 is path only
Path1  = input('Enter path to excel file \n','s');
Path1  = 'C:\Users\Public\';
%File is filename only and Get concatenated
%Path1 and File into one string for the 
%reads and writes
%File = input ('Enter file complete file name \n','s');
File = 'excel_Arrays.xlsx';
get = strcat (Path1, File);
M = xlsread(get,'Sheet1','B3:D5');
M;
%%filename = '3Eq-4Eq.xlsx';
xlswrite(get,'Sheet1','B10:D12');

[Stephen23]

Do NOT use get as a variable name! Doing so will shadow the inbuilt and very important get function.

You forgot to pass M to xlswrite. You should also use fullfile rather than string concatenation:

fnm = fullfile(Path1,File);
M = xlsread(fnm,'Sheet1','B3:D5');
xlswrite(fnm,M,'Sheet1','B10:D12');

[Thomas Rugh]

I tried to do this, but it still did not output to the excel file. Is there something else I have to do?

Answer 1

[Rik]

Replace this

xlswrite(get,'Sheet1','B10:D12');

with this

xlswrite(get,M,'Sheet1','B10:D12');

And you shouldn't overwrite get, so you should change the variable name to something else.

Reading the documentation for xlswrite shows you what options you have for your syntax. The syntax you were using would be xlswrite(filename,A,xlRange), so 'Sheet1' would be the matrix you are writing, which is likely not what you mean.