exporting from matlab to excel

4 次查看(过去 30 天)
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.

采纳的回答

Narges M
Narges M 2013-7-24
编辑:Narges M 2013-7-24
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
Darin McCoy 2013-7-15
I recommend creating sample data so users can mess with what you're working with

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by