How can i make xlsread read successive excel worksheets ?
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
VBBV
el 30 de Jun. de 2018
Respondida: Image Analyst
el 30 de Jun. de 2018
I have a problem reading data from successive excel worksheets within a loop... The size of data in successive sheets are different, when I type the size of stored matrix ... it always shows the size of data in first worksheet ... why ?
2 comentarios
Jan
el 30 de Jun. de 2018
Post your code, such that we can know, what you are actually doing. What does "when I type the size of stored matrix" mean exactly?
Respuesta aceptada
Image Analyst
el 30 de Jun. de 2018
Use
fileName = 'myExample.xlsx'
[status,sheets,xlFormat] = xlsfinfo(fileName )
to get the sheet names, then use xlsread() to open them
for k = 1 : length(sheets)
data = xlsread(fileName, sheets{k});
% Now do something with data....
end
0 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!