How to output a nested cell array data to .csv or .xls
11 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Hello,
I would like to ask, how I can output to a .csv or .xls a nested cell array of following form:
- main cell array is of type 1x152 cell
- every of 152 cell is a 1x6 cell of form { 'string', 'string', 'string', 'string', 'string', 1x4096 double}
Output file should consist of 152 lines.
Thanks in advance for help.
0 Commenti
Risposte (1)
Orion
il 5 Apr 2016
Modificato: Orion
il 5 Apr 2016
Hi,
you can't write this kind of variable in one time.
eventually, you can write it in a xls file using a for loop.
something like
for i = 1:length(mydata)
% write the ith component in the ith sheet
xlswrite('result.xlsx',mydata{i},['sheet_' num2str(i)]);
end
or you can write the first subcell between the columns A to F, then the second subcell between columns G to L, and so on....
0 Commenti
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!