Effacer les filtres
Effacer les filtres

xlswrite substitute that writes to specific columns

11 vues (au cours des 30 derniers jours)
Zeynab Mousavikhamene
Zeynab Mousavikhamene le 10 Avr 2021
Commenté : Jeremy Hughes le 11 Avr 2021
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?

Réponse acceptée

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

Connectez-vous pour commenter.

Plus de réponses (0)

Community Treasure Hunt

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

Start Hunting!

Translated by