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.

[Azzi Abdelmalek]

What is the size of these cell arrays ?

[joseph Frank]

Each vector or array is 140 rows

Answer 1

[Narges M]

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

Answer 2

[Darin McCoy]

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