folders containing excel spreadsheets
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
I have 4 folders each consisting of several (>10) excel spreadsheets. How is it possible to extract the last worksheet of each spreadsheet into matlab. So that in matlab, the data will be such that a cell would represent a folder and within that cell you would have the contents of each folder i.e. the data from the last worksheet of each spreadsheet?
cheers
0 comentarios
Respuestas (1)
Robert Cumming
el 30 de Nov. de 2011
doc dir
doc xlsread
doc cell
should give you somewhere to start...
6 comentarios
Robert Cumming
el 1 de Dic. de 2011
fixed?
clever?
dynamic?
concentrate on loading the data from one file - then expandm rather than trying to solve the problem in one go.
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!