xlsread problems

Submitted by cha on

Dear GraphVar users,

I have some problems with my data. As explained in the tutorial, I have created two files one for Brain regions and one for my variables. I have 78 ROIS and 44 subjects (22 controls and 22 decliners). When I load my xls or my csv files I have an error message:

Error using xlsread (line 247)Subscript indices must either be real positive integers or logicals.

If I change something in the file, i have this error message: Error using xlsread (line 247)Index exceeds matrix dimensions.

This is the first time I have this problem. I have attached my files

Can somebody help me please?

Thanks a lot

All the best,

Cha

Johann Kruschwitz

Mon, 06/15/2015 - 08:47

Permalink

Hi Cha,

I´ve tried opening your files with GraphVar on my computer (Matlab 2011, 2012, 2014) and it works everytime. Can you actually open the sheets in the sample workspace? If you can´t there might be something wrong with your xlsx read settings on your computer. If you can open these, try substituting your variables with the ones in the original sheets that are loaded automatically - this may work. Otherwise I would suggest to use csv instead of xlsx file format (make sure the format is as in the original sheets).

I hope this helps?

Johann

Thanks for your answer. I tried what you adviced to me. I can open the data from the sample workspace. When I try to substitute my data with the ones in the orignical sheets:
- it's ok for the file 'variables"
- it does not work for the file "brainregions". And the .csv also doesn't work. The number of regions is not a problem?
I obtained this error:

Error using xlsread (line 247)
Subscript indices must either be real positive integers or logicals.

Error in importSpreadsheet (line 23)
    [~,~,spread] = xlsread(filename);

Error in GraphVar_loadBrainRegions (line 19)
[BrainMap] = importSpreadsheet(Brain_Atlas);

Error in GraphVar>BrainSelect_Callback (line 226)
    [handles.BrainMap,handles.brain] = GraphVar_loadBrainRegions(hObject, eventdata,
    handles,Brain_Atlas);

Error in gui_mainfcn (line 96)
        feval(varargin{:});

Error in GraphVar (line 40)
    gui_mainfcn(gui_State, varargin{:});

Error in
@(hObject,eventdata)GraphVar('BrainSelect_Callback',hObject,eventdata,guidata(hObject))

 
Error while evaluating uicontrol Callback


Thanks for your advice
All the best
Charlotte

To: rfmri.org@rnet.co
From: rfmri.org@gmail.com
Date: Mon, 15 Jun 2015 08:47:03 +0000
Subject: Re: [RFMRI] xlsread problems
Attachment Size
BrainRegions.xlsx 7.67 KB
Variables.xlsx 5.42 KB
Forums
GraphVar