Not Enough Input Arguments - Error Message

4 visualizzazioni (ultimi 30 giorni)
Amritha Harikumar
Amritha Harikumar il 15 Mar 2018
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 Commenti
Walter Roberson
Walter Roberson il 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
Amritha Harikumar il 19 Mar 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!!

Accedi per commentare.

Risposte (0)

Categorie

Scopri di più su Data Import from MATLAB in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by