Cell array to xlsx file
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have an array of cell sized 1 X 476.
Each element in the cell contains 116 X 1 sized data.
I want to convert this to a 116 X 476 data and write it into an xlsx file.
Could anyone help me with this ? Thanks.
0 commentaires
Réponses (1)
Ran Yang
le 11 Avr 2023
You can concatenate each element of your cell array using cat or convert the cell array to a regular array using cell2mat. Then save as a spreadsheet.
x = {[1;2;3], [10;11;12]} % sample data (cell size 1x2, each cell contains data 3x1)
y = cat(2, x{:})
y = cell2mat(x)
writematrix(y, 'table.xlsx');
0 commentaires
Voir également
Catégories
En savoir plus sur Cell Arrays dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!