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

1 次查看（过去 30 天）
Alun Owen
Alun Owen 2016-1-21
评论： 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

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

采纳的回答

Walter Roberson
Walter Roberson 2016-1-22
combined = [sample1, sample2];
xlswrite('New_1.csv', combined);
  2 个评论
Alun Owen
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
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.

请先登录，再进行评论。

更多回答（1 个）

Chetan Rawal
Chetan Rawal 2016-1-22
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

类别

在 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