How to read several times similarly from EXCEL?
조회 수: 1 (최근 30일)
이전 댓글 표시
How can we read data from Excel for similar sheet names and even file names, I mean in a loop?
for example, we want to read data from sheets A1,A2,...A100 from an Excel file.
Can we do it in a loop? I couldn't!
Things like this do not work:
for i =1:100
sheet= 'A(i)'
E1 = xlsread('filename', sheet,'range')
or
sheet= 'Ai'
sheet= 'A% i'
How can we do so?
Thanks
Steven
댓글 수: 0
채택된 답변
Azzi Abdelmalek
2013년 12월 29일
편집: Azzi Abdelmalek
2013년 12월 29일
for k=1:100
sheet= sprintf('A%d',k)
E{k}= xlsread('filename', sheet)
end
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!