Help: Excel manipulation in Matlab
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi,
I have some questions and hope somebody help me. I'm working with excel input data. It's in colum A, B, C , D, etc. The number of colums is not specified. It depends on users. How could I know the number of the colums on each different situation? And with a same "for loop" statement, how could I automatically execute with colums A, B, C, etc.
Khanh
0 commentaires
Réponse acceptée
Iain
le 16 Sep 2014
You probably don't need a for loop:
The function "xlsread" reads in the contents of an entire sheet (ALL columns), by default, but you can also set it up so that it makes you select the region of pixels to be imported to matlab.
What you do with your 3 matrices of values & text is up to you.
[numbersonly textonly everything] =xlsread(filename,sheetno);
2 commentaires
Plus de réponses (0)
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!