MATLAB Answers

0

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

Asked by Alun Owen on 21 Jan 2016
Latest activity Commented on by Walter Roberson
on 23 Jan 2016
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 Comments

Sign in to comment.

2 Answers

Answer by Walter Roberson
on 22 Jan 2016
 Accepted Answer

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

  2 Comments

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

Sign in to comment.


Answer by Chetan Rawal on 22 Jan 2016

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

  0 Comments

Sign in to comment.