Help reading Excel files

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.

Answer 1

[Héctor Corte]

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.