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 Kommentare

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 am 19 Mär. 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 am 19 Mär. 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!!

Melden Sie sich an, um zu kommentieren.

Antworten (0)

Kategorien

Gefragt:

am 15 Mär. 2018

Kommentiert:

am 19 Mär. 2018

Community Treasure Hunt

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

Start Hunting!

Translated by