Split excel file and get ordered splittedfile names
显示 更早的评论
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
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 个评论
Adi Purwandana
2023-10-10
Adi Purwandana
2023-10-10
dpb
2023-10-10
data.Station=findgroups(data.Station);
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
