excel data into a single columns using loop

3 次查看（过去 30 天）
LIM JIAXIN
LIM JIAXIN 2018-9-30
评论： ANKUR KUMAR 2018-10-1
Does anyone know how to make this data into a single columns with spacing interval using for loop? from top data to bottom data
.

请先登录，再回答此问题。

采纳的回答

ANKUR KUMAR
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 个评论
显示 10更早的评论
LIM JIAXIN
LIM JIAXIN 2018-10-1 
 https://www.dropbox.com/s/ee9sfwk6z15ntkk/example.xlsx?dl=0 the excel file is inside the link as i reached the limit of uploading files right now. So my input is under sheet 1 and the desired output can be seen from sheet 2.
ANKUR KUMAR
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 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by