what are steps to create a combination array ?

1 次查看（过去 30 天）
mohammad
mohammad 2014-2-19
编辑： Andrei Bobrov 2014-2-21
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

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

回答（2 个）

Ilham Hardy
Ilham Hardy 2014-2-20
doc xlsread
doc xlswrite
to combine array
C = [A B]; or C = [A,B];
  1 个评论
mohammad
mohammad 2014-2-21
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

请先登录，再进行评论。

Andrei Bobrov
Andrei Bobrov 2014-2-21
编辑：Andrei Bobrov 2014-2-21
[~,~,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);

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by