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

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

Answer 1

[Walter Roberson]

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

[Alun Owen]

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]

"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]

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