How to select and write values from data into excel
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have a single column of 98820 values i want to divide them into groups of 4941 and write them in separate columns in excel
0 commentaires
Réponse acceptée
Jan
le 23 Fév 2017
x = rand(98820, 1);
y = reshape(x, 4941, 20);
xlswrite(FileName, y);
3 commentaires
Image Analyst
le 25 Fév 2017
Correct (though this more general question wasn't asked). If the vector is not an integer multiple of the number in a group, then Arslan should choose a different group size or else re-think what he wants to do. For the stated numbers, this works.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets 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!