read multiple excel files with different file names ?
조회 수: 4 (최근 30일)
이전 댓글 표시
I want to multiple excel files with different file names like R1 (1).xlsx, R1 (2).xlsx, R1 (3).xlsx........... till R1 (30).xlsx and want to extract data having same sheet name and column number in each excel files. lets say Sheet name is "ABC" in each excel file and want to extract column T and U from this sheet from all the sheets.
답변 (1개)
KSSV
2020년 8월 27일
xlFiles = dir("*.xlsx") ;
N = length(xlFiles) ;
for i = 1:N
thisFile = xlFiles(i).name ;
T = readtable(thisFile) ;
% do what you want
end
댓글 수: 4
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!