Info
Cette question est clôturée. Rouvrir pour modifier ou répondre.
how to write a matrix to spesific excel row?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi everybody,
I have an 91x1 matrix and ı want to add this matric to excels F (Columns A to E are already full )column. I try to use xlswrite('testset.xls',classval','F1'); code but it deleted the other columns and writes the matrix on A column
0 commentaires
Réponses (1)
Giuseppe Inghilterra
le 8 Fév 2020
Hi,
when you use xlswrite function, if you don't specify "sheet" as input argument, you must write the range in rectangular shape. In your case:
xlswrite(filename,matrix,'F1:F91');
If you want to deepen how to use xlswrite function, you can see: https://it.mathworks.com/help/matlab/ref/xlswrite.html
2 commentaires
Giuseppe Inghilterra
le 10 Fév 2020
If you don't specify sheet name, you must define xlsrange in rectangular shape. If you write only the starting point as 'F1:F1', only the first matrix entry is written. Instead if you write the column 'F:F', the column F is filled with matrix values and then other values are filled with N/A values.
You can overcome this problem by specifying sheet name:
xlswrite('testset.xlsx',classval','sheetname','F1');
In this way you can indicate only the starting point without taking care of matrix dimension.
Voir également
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!