How to import different columns for example A, G, O or series of columns e.g. every 8 columns from excel

Question

Alun Owen 2016-1-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/264703-how-to-import-different-columns-for-example-a-g-o-or-series-of-columns-e-g-every-8-columns-from-e

评论： Walter Roberson 2016-1-23

I am very new to Matlab and I am struggling to import different columns for example A, G, O or series of columns e.g. every 8 columns from excel into matlab. I have managed to create code that imports individual columns into cell arrays

[numbers, strings, raw] = xlsread('1.csv');
Excitation = raw(1:153,A); emission = raw(1,); 
sample1 = raw(1:153,A); 
sample2 = raw(1:153,B);

but I am then having issues trying to export the cell arrays back together into one worksheet in excel. Could someone point me in the right direction (sorry if this is an obviously basic step

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2016-1-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/264703-how-to-import-different-columns-for-example-a-g-o-or-series-of-columns-e-g-every-8-columns-from-e#answer_207013

在 MATLAB Online 中打开

combined = [sample1, sample2];
xlswrite('New_1.csv', combined);

2 个评论
显示无隐藏无

Alun Owen 2016-1-22

Thank you Walter, I couldn't get "combine" to work but then realised I could use: horzcat = [sample1, sample2]; xlswrite('New_1.csv', horzcat); Thankyou for pointing me in the right direction.

Walter Roberson 2016-1-23

"combined" is just a variable name here, not an option name. It should better than "horzcat" as "horzcat" is the name of an important MATLAB function. I notice you mention "combine" rather than "combined" which suggests you might have made a typing mistake.

请先登录，再进行评论。

Answer 2

Chetan Rawal 2016-1-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/264703-how-to-import-different-columns-for-example-a-g-o-or-series-of-columns-e-g-every-8-columns-from-e#answer_207007

Hi Alun,

Since you are new, and using MATLAB with Excel, the following is the best place to learn and get your answer: http://www.mathworks.com/discovery/matlab-excel.html