Split excel file and get ordered splittedfile names

1 次查看（过去 30 天）
Adi Purwandana
Adi Purwandana 2023-10-10
评论： dpb 2023-10-10
Dear everyone,
I have the lines as follow which splits an excel file into some excel files based on the number of Stations inside.
data = readtable('data.xlsx');
stations = unique(data.Station);
for i=1:numel(stations)
x = data(data.Station==stations(i), :);
writetable(x,"Sta_"+num2str(stations(i))+".xlsx");
end
The file I need to split is like this:
Then, my code above will generate three excel files from this excel file : Station_2.xlsx, Station_31.xlsx, Station_42.xlsx.
What I want is... Set a new file name with ordered rank : Station_1, Station_2, Station_3.
So, here I want
Station_2 ---> becomes Station_1.xlsx
Station_31 ---> becomes Station_2.xlsx
Station_42 ---> becomes Station_3.xlsx
warm regards

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

采纳的回答

dpb
dpb 2023-10-10
Just use the looping index..
data = readtable('data.xlsx');
stations = unique(data.Station);
for i=1:numel(stations)
x = data(data.Station==stations(i), :);
writetable(x,"Station_"+ i +".xlsx");
end
  3 个评论
显示 1更早的评论
Adi Purwandana
Adi Purwandana 2023-10-10
Anyway, is it possible also to change the value of Station column so that following the ordered file name? I asked this in separated Ask thread indeed : question.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by