How to read multiple excel files with pattern in their names
조회 수: 1 (최근 30일)
이전 댓글 표시
As the title says, I want to read multiple excel files that have a pattern in their names.
The file names start from 1000 to 100000, increasing with an interval of 1000.
Thanks in advance.
댓글 수: 0
답변 (2개)
Bhaskar R
2019년 11월 3일
% assuming working in the present working directory
files = 1000:1000:100000;
file_data = cell(1, length(files));
for iFile = 1:length(files)
% in string concatamatiom
% 1 - if filename has any pre string
% 2 - for loop varibale from 1000:1000:100000
% 3 - file extension
str = ['file_pre_string_if_any_', num2str(iFile), '.xlsx'];
file_data{iFile} = xlsread(str); % excel data will be stored in the variable file_data
end
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!