Effacer les filtres
Effacer les filtres

Help reading Excel files

3 vues (au cours des 30 derniers jours)
Amir Hamzah UTeM
Amir Hamzah UTeM le 10 Fév 2011
How do I let MATLAB know how many columns in my Excel file when I'm loading it in a GUI? Let's say I have 22 values in the first column. How can I let MATLAB know it was a 22nd column or n-th column?
I hope someone can help me with some code example for my learning.

Réponses (1)

Héctor Corte
Héctor Corte le 10 Jan 2012
With this code you get value on cell (A , fila):
ActivesheetRange = get(Activesheet,'Range',['A',num2str(fila)]);
To check if this cell is empty you can use:
isnan(ActivesheetRange.value)
Make a loop that looks for a empty cell along a row and you will get how many columns you have.

Tags

Produits

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by