export matrix into Excel
29 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Rebecca Hadley
le 19 Fév 2019
Commenté : Jesus Sanchez
le 4 Mar 2019
Hi,
I'm trying to export a matrix called xyzCGAT into Excel (three columns and 60480000 rows for each column). I've tried using xlswrite (code below) and it produces the error:
Error using xlswrite (line 172)
Input data must be a numeric, cell, or logical array.
Error in conversion_to_excel (line 5)
xlswrite(filename,A);
The values within the matrix are acceleration values and some are negative so therefore include a minus symbol infront of the value. Is this causing the issue?
Any advice about where I'm going wrong or how to convert such values to an Excel file would be really appreciated. Thanks in advance!
load xyzCGAT.mat
A = table (1,2,3)
A(:,1:3)
filename= 'xyzCGAT.xlsx'
xlswrite(filename,A);
0 commentaires
Réponse acceptée
Jesus Sanchez
le 19 Fév 2019
Modifié(e) : Jesus Sanchez
le 19 Fév 2019
xlswrite only works with matrixes and you created a table. You are looking for the function called "writetable"
PS: As you are working with tables, it is possible to call each row of the table with a name, which later on will also be saved to the excel file, txt file or whichever you want. In the link provided above there are good examples of that.
EDIT: An example in your code:
writetable(A,filename);
8 commentaires
Jesus Sanchez
le 4 Mar 2019
Hello,
please create a new and separate topic for this. I am not sure of that error and, as this is a question that already has an answer, it will not appear for that many people
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!