How to read xlsx file after the date
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Jingying Wang
el 22 de Dic. de 2017
Respondida: Ramnarayan Krishnamurthy
el 29 de Dic. de 2017
Hi everyone. I want to read the file by date. That means, the first produced file should be read first and then second and so on. The name of xlsx file looks like: (CS2_33_D_M_Y) CS2_33_8_17_10 CS2_33_8_18_10 CS2_33_8_19_10
0 comentarios
Respuestas (1)
Ramnarayan Krishnamurthy
el 29 de Dic. de 2017
A possible approach would be to pull out the date from the file name and then sort it. Then, keep a track of the order and read the files in that order.
As an example:
% Sample file names in a cell array
A = {'CS2_33_10_17_10'; 'CS2_33_10_10_10'; 'CS2_33_8_1_12'; 'CS2_33_8_18_11' ; 'CS2_33_1_1_01'};
% Reading the date part of the file assuming the prefix CS2_33_ is a constant amongst filenames
for i=1:length(A)
a{i}=sscanf(A{i}, 'CS2_33_%s');
end
% Sorting the dates and tracking the changes to the indices
[~,j] = sortrows(datenum(a))
% A{j} contains filenames in the ascending order of dates
xlsread(A{j})
If you are interested in using the "intrinsic" timestamp of the files, the following link may be useful: https://www.mathworks.com/matlabcentral/answers/33220-how-do-i-get-the-file-date-and-time
0 comentarios
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!