How to read the designated position date in excel

Question

chengxuan yu 2013-6-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/80407-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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

David Sanchez 2013-6-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/80407-how-to-read-the-designated-position-date-in-excel#answer_90103

在 MATLAB Online 中打开

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

type

help xlsread

or

doc xlsread

for more options.

2 个评论
显示无隐藏无

chengxuan yu 2013-6-27

编辑：chengxuan yu 2013-6-27

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 2013-6-27

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?

请先登录，再进行评论。