xlswrite substitute that writes to specific columns

I would like to write a matrix to specific columns and rows of excel. xlswrite has this option but for compatibility issues I would want to find a substitue for it. Writetable or writematrix does not have this option (xlswrite(filename,A,xlRange)).

Any idea?

Answer 1

[Jeremy Hughes]

This syntax is equivalent to writematrix(A,filename,'Range',xlRange)

[Zeynab Mousavikhamene]

I receive this error:

Error using strlength
First argument must be text.

Error in writematrix (line 147)
        n = strlength(varargin{i});

Error in Boundaryfinder (line 57)
writematrix(fullFileNameofxy,B(:,2),sheet,xlRange)

B(:,2) is a colmun of numbers. xlRange is 'A2' and sheet is 1.

[Jeremy Hughes]

https://www.mathworks.com/help/matlab/ref/writematrix.html

Note the signatures are different.

The first input is the data, and the second input is the file name. Subsequent inputs need to be Name-Value pairs.

The correct calling syntax would be:

writematrix(B(:,2),fullFileNameofxy,'Sheet',sheet,'Range',xlRange)