Split excel file and get ordered splittedfile names
조회 수: 1 (최근 30일)
이전 댓글 표시
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:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1507584/image.png)
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
댓글 수: 0
채택된 답변
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
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!