MATLAB Answers

xlswrite substitute that writes to specific columns

7 views (last 30 days)
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?

Accepted Answer

Jeremy Hughes
Jeremy Hughes on 10 Apr 2021
This syntax is equivalent to writematrix(A,filename,'Range',xlRange)
  2 Comments
Jeremy Hughes
Jeremy Hughes on 11 Apr 2021
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)

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!