excel data into a single columns using loop
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Does anyone know how to make this data into a single columns with spacing interval using for loop? from top data to bottom data
.
Réponse acceptée
ANKUR KUMAR
le 30 Sep 2018
What do you mean by equal spacing between each column. You cannot keep blank any element in matrix. You can do in cell. Here is an example.
A=xlsread('example.xlsx') reshape(A,[],1) %if you want without keeping blank between each column B=arrayfun(@(x) num2str(x) , A,'uni',0); C=[B';{'','','';'','',''}]; reshape(C,[],1)
12 commentaires
ANKUR KUMAR
le 1 Oct 2018
A=xlsread('example.xlsx') A(2,:)=[]; reshape(A,[],1) %if you want without keeping blank between each column B=arrayfun(@(x) num2str(x) , A,'uni',0) C=[B;{'','','';'','',''}]; reshape(C,[],1)
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Logical 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!