transfer Matlab Workspace to Excel
10 views (last 30 days)
Show older comments
Hello
i wanted to know how to transfer the data i have in my workspace to Excel automatically after running my code, my data are only numbers.
For example if this is my Workspace:
i want this to be the excel Table:
how can i do this ?
Thank you.
0 Comments
Accepted Answer
dpb
on 24 Sep 2023
Moved: dpb
on 24 Sep 2023
Easiest would be to use arrays instead of a zillion sequentially named individual variables; associate a string array of names with them if desired (for the example, it could be simply an expression such as
nColumns=size(yourNewArrayReplacingVariables,2);
tT=array2table(yourNewArrayReplacingVariables,'VariableNames',cellstr(char('a'+[0:N-1].')));
writetable('yourExcelFile.xlsx',tT,'WriteVariableNames',1)
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!