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!