Ordering the name of excel files from short to longer length

1 次查看（过去 30 天）

显示更早的评论

Adi Purwandana 2023-9-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2019706-ordering-the-name-of-excel-files-from-short-to-longer-length

评论： Adi Purwandana ，2023-9-12

采纳的回答： kei hin ，

Hello everyone,

I have a script which split an excel file into several excel files using this code:

data = readtable('dataset.xlsx');
stations = unique(data.Station);
for i=1:numel(stations)
    x = data(data.Station==stations(i), :);
    writetable(x,"Sta_"+num2str(stations(i))+".xlsx");
end

FYI, each file created using such code has different lengths. For example:

Sta_1 --> 8 rows;

Sta_2 --> 3 rows;

Sta_3 --> 6 rows.

My question is... is it possible to order from the shorter length to longer length when using writable function?

So, I want the file names is ordered based on the length of the file, i.e.,

Sta_1 --> file with 3 rows;

Sta_2 --> file with 6 rows;

Sta_3 --> file with 8 rows.

Thanks

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

请先登录，再进行评论。

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

采纳的回答

kei hin 2023-9-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2019706-ordering-the-name-of-excel-files-from-short-to-longer-length#answer_1307481

编辑：kei hin 2023-9-12

Check the length inside the for loop and store the sorted result in variables, then use the writetable outside the for loop.

3 个评论
显示 2更早的评论隐藏 2更早的评论

Adi Purwandana 2023-9-12

It perfectly works! Thank you very much @kei hin!

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

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

产品

MATLAB

版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by