Help reading Excel files

2011 2 10
1 个回答
3 次查看（30 天）

0 个投票

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.

请先登录，再回答此问题。

回答（1 个）

Héctor Corte
Héctor Corte 2012-1-10

0 个投票

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.

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by