xlswrite substitute that writes to specific columns

5 次查看（过去 30 天）
Zeynab Mousavikhamene
评论： Jeremy Hughes 2021-4-11
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?

请先登录，再回答此问题。

采纳的回答

Jeremy Hughes
Jeremy Hughes 2021-4-10
This syntax is equivalent to writematrix(A,filename,'Range',xlRange)
  2 个评论
Zeynab Mousavikhamene
Zeynab Mousavikhamene 2021-4-10
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
Jeremy Hughes 2021-4-11
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)

请先登录，再进行评论。

更多回答（0 个）

类别

在 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