Not Enough Input Arguments - Error Message
Show older comments
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 Comments
Venkata Siva Krishna Madala
on 19 Mar 2018
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
on 19 Mar 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
on 19 Mar 2018
Answers (0)
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!