Filter löschen
Filter löschen

exporting from matlab to excel

3 Ansichten (letzte 30 Tage)
joseph Frank
joseph Frank am 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 Kommentare
Azzi Abdelmalek
Azzi Abdelmalek am 14 Jul. 2013
What is the size of these cell arrays ?
joseph Frank
joseph Frank am 24 Jul. 2013
Each vector or array is 140 rows

Melden Sie sich an, um zu kommentieren.

Akzeptierte Antwort

Narges M
Narges M am 24 Jul. 2013
Bearbeitet: Narges M am 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

Weitere Antworten (1)

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

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by