How to read the designated position date in excel

2 次查看（过去 30 天）
chengxuan yu
chengxuan yu 2013-6-27
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?

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

采纳的回答

David Sanchez
David Sanchez 2013-6-27
% 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
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
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?

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by