How to read several times similarly from EXCEL?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Steven
am 29 Dez. 2013
Kommentiert: Steven
am 29 Dez. 2013
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 Kommentare
Akzeptierte Antwort
Azzi Abdelmalek
am 29 Dez. 2013
Bearbeitet: Azzi Abdelmalek
am 29 Dez. 2013
for k=1:100
sheet= sprintf('A%d',k)
E{k}= xlsread('filename', sheet)
end
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!