excel data into a single columns using loop
2 ビュー (過去 30 日間)
古いコメントを表示
Does anyone know how to make this data into a single columns with spacing interval using for loop? from top data to bottom data
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/196808/image.png)
.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/196809/image.png)
採用された回答
ANKUR KUMAR
2018 年 9 月 30 日
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 件のコメント
ANKUR KUMAR
2018 年 10 月 1 日
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)
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!