exporting from matlab to excel
显示 更早的评论
I have 236 vectors and arrays named A, B, C.....etc... Some of them are cell arrays and some of them are double vectors. How can I export the data to excel in one sheet where the order of variables is alphabetical? mixing arrays and vectors are a challenge to me as well as exporting them alphabetically in one sheet.
采纳的回答
use this example:
A = {1;2;3;4};
B = [9;8;7;6];
C = {5;6;7;8};
D = [5;4;3;2];
for i='A':'D'
eval(sprintf('last = length(%s);', i));
eval(sprintf('xlswrite(''C:\\test.xls'',%s,1,''%s1: %s%d'');',i,i,i,last));
end
更多回答（1 个）
Darin McCoy
2013-7-15
0 个投票
I recommend creating sample data so users can mess with what you're working with
Have you checked out this solution on FEX? http://www.mathworks.com/matlabcentral/fileexchange/7601-cell2csv
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
2013-7-14
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
