XLSwrite to write in a different column in each iteration

ARS
2012 4 4
2 个回答
回答已采纳
3 次查看（30 天）

1 个投票

Hi all,
I am Sorting the first column of a Dataset Array by using sortrows() and writing the sorted column(values) as it is to excel sheet via XLS write by using the following:
for k=1:40,
sorted=sortrows(rr2,k);
xlswrite('rr2.xls', sorted.Assets , 'XLsheet',['A' num2str(k)]);
end
but the above code changes the row number with counter....I want to write the sorted values to the next excel column in each iteration,,,for example columns from A to AN.
How can I do this?
Regards,
AMD.

2 个评论
显示 无 隐藏 无

ARS
ARS 2012-4-4
Hi Andrei,
RR2 is a Dataset Array of dimension 6x41 .
I need the first column of RR2 (a list of names) to be sorted by col 1 to 40.....and the sorted named list be exported to excel in a different column in each iteration.
or Any procedure which makes this desired matrix in matlab and the whole sheet be written to MATLAB...
Thanks.

请先登录，再进行评论。

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

 采纳的回答

ARS
ARS 2012-4-5

1 个投票

Hi,
This solves the purpose...first create a dataset array of sorted names and then export to excel....
for k=1:39,
sorted=sortrows(rr2,k);
sorted1(:,k)=sorted(:,1);
end
export(sorted1,'XLSfile','rr2.xls');
where sorted,rr2 and Sorted1 are dataset arrays of dimension 6x40.

更多回答（1 个）

Andrei Bobrov
Andrei Bobrov 2012-4-5

0 个投票

EDITED on Ahmad comment
[~,isrd] = sort(double(rr2(:,2:end)));
N = cellstr(rr2(:,1));
xlswrite('rr2.xlsx',N(isrd));

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

ARS
ARS 2012-4-5
Thanks Andrei...This produces the following errors:
??? Undefined function or method 'sort' for input arguments of type 'dataset'.
?? Undefined variable rr.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Shifting and Sorting Matrices 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by