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 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by