excel data into a single columns using loop

2 次查看（过去 30 天）

LIM JIAXIN 2018-9-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/421452-excel-data-into-a-single-columns-using-loop

评论： 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

2 个评论
显示无隐藏无

Stephen23 2018-9-30

Original question:

https://www.mathworks.com/matlabcentral/answers/420493-extracting-data-from-excel-and-rewrite-it-into-specific-cell-in-a-loop

LIM JIAXIN 2018-9-30

Hi stephen, the answer provided by the link doesnt help. maybe you can help me?

请先登录，再进行评论。

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

采纳的回答

ANKUR KUMAR 2018-9-30

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/421452-excel-data-into-a-single-columns-using-loop#answer_339081

example.xlsx

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更早的评论隐藏 10更早的评论

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 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)

请先登录，再进行评论。