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
采纳的回答
Walter Roberson
2016-1-22
combined = [sample1, sample2];
xlswrite('New_1.csv', combined);
2 个评论
Alun Owen
2016-1-22
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
2016-1-22
0 个投票
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
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
