export matrix into Excel
23 views (last 30 days)
Show older comments
Rebecca Hadley
on 19 Feb 2019
Commented: Jesus Sanchez
on 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 Comments
Accepted Answer
Jesus Sanchez
on 19 Feb 2019
Edited: Jesus Sanchez
on 19 Feb 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 Comments
Jesus Sanchez
on 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
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!