Split excel file and get ordered splittedfile names

Question

Adi Purwandana 2023-10-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2031709-split-excel-file-and-get-ordered-splittedfile-names

评论： dpb 2023-10-10

采纳的回答： dpb

在 MATLAB Online 中打开

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

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

请先登录，再进行评论。

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

Answer 1

dpb 2023-10-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2031709-split-excel-file-and-get-ordered-splittedfile-names#answer_1330299

在 MATLAB Online 中打开

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更早的评论隐藏 1更早的评论

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.