Read 'next sheet' in excel file
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have multiple excel files with many sheets of different name. (5 excel files, each has >20 worksheets)
my objective is to read cell B2 from every sheet and store them in a big matrix
its really really time consuming to write something like this f=xlsread(InputFileName1,sheet1,'B2'); f=xlsread(InputFileName1,sheet2,'B2'); f=xlsread(InputFileName1,sheet3,'B2'); f=xlsread(InputFileName1,sheet4,'B2'); etc...
every sheet is nammed differently, so in the above example, i have to rename every single sheet (again time consuming)
xlsread is a very slow command, is there a more efficient way to read all one shot? or any command to "read next sheet", so i dont have to rename the sheet name one by one in my m file?
please help, thanks:-)
0 commentaires
Réponses (1)
Image Analyst
le 19 Juil 2012
You need to use ActiveX. Search the Answers forum for examples, or use Brett's code: http://www.mathworks.com/matlabcentral/fileexchange/4415-readfromexcel
0 commentaires
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!