data import error in line 1

1 次查看（过去 30 天）
desert_scientist90
desert_scientist90 2019-10-1
评论： Steven Lord 2019-10-10
Hi I am trying to import a excel document to matlab by using the code below. However I am getting the message error in line one. I have try differents approached such as data = load but no results. Any help will be aprreciated.
data = xlsread('station.xlxs' ,1,'A2:E457');
pi = 3.14159;
jun_aug_1 = data(:,1);
jun_aug_2 = data(:,2);
dec_feb_1 = data(:,3);
dec_feb_2 = data(:,4);
  4 个评论
显示 2更早的评论
desert_scientist90
desert_scientist90 2019-10-1
Hi, Walter.
Yes, I tried both. It might be a silly error but is driving me crazy.
Error in hw21 (line 1)
data = xlsread('station.xlxs' ,1,'A2:E457');
Error in hw21 (line 1)
data = readtable('station.xlxs' ,1,'A2:E457');
Steven Lord
Steven Lord 2019-10-10
As an aside, there's no need for you to define pi. MATLAB already has a function for that.

请先登录，再进行评论。

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

回答（1 个）

desert_scientist90
desert_scientist90 2019-10-1
Found the error I fliped the excel format, below is the right code
data = xlsread('station.xlsx',1,'A2:E457');
pi = 3.14159;
jun_aug_1 = data(:,1);
jun_aug_2 = data(:,2);
dec_feb_1 = data(:,3);
dec_feb_2 = data(:,4);
  1 个评论
Walter Roberson
Walter Roberson 2019-10-1
Ah, you had an error in the file extension so the file did not exist.

请先登录，再进行评论。

类别

在 Help Center 和 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