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 个评论

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';
Amritha Harikumar: is it correct that you are on Mac? Or in particular that you are not on MS Windows with Excel installed?
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!!

请先登录,再进行评论。

回答(0 个)

类别

帮助中心File Exchange 中查找有关 Data Import from MATLAB 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by