data import error in line 1

2 visualizaciones (últimos 30 días)
desert_scientist90
desert_scientist90 el 1 de Oct. de 2019
Comentada: Steven Lord el 10 de Oct. de 2019
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 comentarios
desert_scientist90
desert_scientist90 el 1 de Oct. de 2019
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 el 10 de Oct. de 2019
As an aside, there's no need for you to define pi. MATLAB already has a function for that.

Iniciar sesión para comentar.

Respuestas (1)

desert_scientist90
desert_scientist90 el 1 de Oct. de 2019
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 comentario
Walter Roberson
Walter Roberson el 1 de Oct. de 2019
Ah, you had an error in the file extension so the file did not exist.

Iniciar sesión para comentar.

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by