MATLAB Answers

exporting from matlab to excel

3 views (last 30 days)
joseph Frank
joseph Frank on 14 Jul 2013
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.
  2 Comments
joseph Frank
joseph Frank on 24 Jul 2013
Each vector or array is 140 rows

Sign in to comment.

Accepted Answer

Narges M
Narges M on 24 Jul 2013
Edited: Narges M on 24 Jul 2013
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

More Answers (1)

Darin McCoy
Darin McCoy on 15 Jul 2013
I recommend creating sample data so users can mess with what you're working with

Products

Community Treasure Hunt

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

Start Hunting!