How to read the designated position date in excel

Thanks in advance, any comment will be appreciated. I have an excel including some ruled datas. Everyone knows that a data in excel has a designated position,eg A1 or B2,and so on... I want to read the data in A1, but I know the data is empty in the first row of excel. How can I read it?

Answer 1

[David Sanchez]

    % Read a specific range of data:
    subsetA = xlsread('myExample.xls', 1, 'B2:C3')

type

help xlsread

or

doc xlsread

for more options.

[chengxuan yu]

I know the meaning of 'B2:C3',but when the 'B2' row is empty,it read the data from 'B3:C3', which is not I want to get. I want to get all the number of 'B2:C3',even when the B2 arrow number is empty , It can use NaN to instead.

[chengxuan yu]

The program can work in maltab7.0, which can not work in matlab2013a. When the program read empty arrow in matlab2013a , it put out from next arrow. Did this is a version problem?