Split Excel file into several Excel Files or several Mat Files based on values of a column

3 次查看(过去 30 天)
Hello everyone,
I have an excel file with several columns:
Does anyone know how to split this file into some EXCEL files or MAT files based on the similar value of the first column? in this case, there are 3 values (1, 2, 3) so this file will be splitted into 3 excel files. Let's say the first file name will be Sta_1, the second file name will be Sta_2 and so on.
best regards

采纳的回答

VINAYAK LUHA
VINAYAK LUHA 2023-9-9
编辑:VINAYAK LUHA 2023-9-9
Hi Adi,
As per my understanding you wish to organize your data into separate excel files based on the data values in Station column.
Here's how this can be done -
data = readtable(pathToExcelFile)
stations = unique(data.Station)
for i=1:numel(stations)
x = data(data.Station==stations(i), :);
writetable(x,"Sta_"+num2str(stations(i))+".xlsx");
end
Hope this helps
  3 个评论

请先登录,再进行评论。

更多回答(0 个)

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by