Clear Filters
Clear Filters

what are steps to create a combination array ?

1 view (last 30 days)
mohammad
mohammad on 19 Feb 2014
Edited: Andrei Bobrov on 21 Feb 2014
what are steps to create a combination array which are given through imported excel sheet then exporting the results to anther excel sheet ? note:the elements of the table are numbers

Answers (2)

Ilham Hardy
Ilham Hardy on 20 Feb 2014
doc xlsread
doc xlswrite
to combine array
C = [A B]; or C = [A,B];
  1 Comment
mohammad
mohammad on 21 Feb 2014
Thank you for your answer, but this is not what I want . please visit this site and you will find what i need exactly but through the matlab functions and not through Excel function http://stackoverflow.com/questions/10692653/excel-vba-to-create-every-possible-combination-of-a-range?answertab=oldest#tab-top

Sign in to comment.


Andrei Bobrov
Andrei Bobrov on 21 Feb 2014
Edited: Andrei Bobrov on 21 Feb 2014
[~,~,c] = xlsread('E:\xlsfile1.xlsx');
c1 = c(3:end,:);
ii = cellfun(@(x)all(~isnan(x)),c1);
n = sum(ii);
idx = bsxfun(@plus,fliplr(fullfact(n)),[0 cumsum(n(1:end-1))]);
c2 = c1(ii);
out = c2(idx);
xlswrite('E:\newxlsfile.xlsx',out);

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!