清空筛选条件
清空筛选条件

XLSwrite to write in a different column in each iteration

2 次查看（过去 30 天）
ARS
ARS 2012-4-4
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
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
EDITED on Ahmad comment
[~,isrd] = sort(double(rr2(:,2:end)));
N = cellstr(rr2(:,1));
xlswrite('rr2.xlsx',N(isrd));
  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.

请先登录，再进行评论。

类别

在 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