How to read xlsx file after the date
2 views (last 30 days)
Show older comments
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 Comments
Answers (1)
Ramnarayan Krishnamurthy
on 29 Dec 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 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!