Not Enough Input Arguments - Error Message

Hi, I am trying to read an excel file with some code, with a 121x35 matrix. However, I think MATLAB is having difficulty processing such a big matrix, and I end up getting the following error:
Error using xlsread (line 260)
Not enough input arguments.
I tried running a test script, and xlsread worked fine on a smaller matrix. But, I am not sure how to get it to run for a bigger one. Here is the full line of code:
file = '/Users/amrithah/Desktop/Databases/Original Data/FC Matrices_Orig.xlsx';
m = xlsread(file,'ADHD_GSR'); %ADHD_GSR is a sheet in the file
m = [m(2:end,1:end-1);NaN([1,size(m,2)-1])]; %NaN removes all subsequent 'Inf' or 'NaN' cells
% group 1
a = m;
The point of this code is to read and extract the excel sheet, and subsequently input it into a variable called 'a', while excluding all NaN or Inf values.
Any help would be appreciated, thanks.

3 comentarios

I have tried for a it on an excel file having 2 sheets of 121x35 data and could not get the same error. Perhaps try giving the absolute path of the file i.e.
file = 'C:/Users/amrithah/Desktop/Databases/Original Data/FC Matrices_Orig.xlsx';
Walter Roberson
Walter Roberson el 19 de Mzo. de 2018
Amritha Harikumar: is it correct that you are on Mac? Or in particular that you are not on MS Windows with Excel installed?
Amritha Harikumar
Amritha Harikumar el 19 de Mzo. de 2018
Hi,
I actually got it to work - the issue was that I didn't specify the cells in the sheet, and it was throwing back an error. Thanks!!

Iniciar sesión para comentar.

Respuestas (0)

Categorías

Más información sobre Data Import from MATLAB en Centro de ayuda y File Exchange.

Preguntada:

el 15 de Mzo. de 2018

Comentada:

el 19 de Mzo. de 2018

Community Treasure Hunt

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

Start Hunting!

Translated by