excel files
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have a folder with several excel spreadsheets, each excel spreadsheet contains data for a certain time period i.e. the first spreadsheet contains data from day 1:20, then the second contains data from 21:40 and so on towards day 365 (so I have 19 spreadsheets in total). Each of the spreadsheets then contain several worksheets which correspond to different days of that time period but with the first and last worksheet corresponding to notes. So, I need to take the worksheets between the first and last worksheets and make them into one matrix. After making each spreadsheet into one matrix I would then like to combine the matrices into one matrix (all will have the same number of columns).
I am totally stuck so any ideas you have will be much appreciated.
thanks
0 commentaires
Réponses (1)
Fangjun Jiang
le 15 Nov 2011
Show your code and show where you were stuck.
xlsread() can read individual sheet. You just need two for-loops nested to read the data and concatenate them together.
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!