clairelbromley / ZebrafishKymographing

Various software tools written for analysis of lumen opening and membrane retraction in zebrafish.
1 stars 0 forks source link

Error when trying to use Viewer, this appears after metadata has been selected #108

Closed clairelbromley closed 7 years ago

clairelbromley commented 7 years ago

viewerMain Warning: Inputs must be character arrays or cell arrays of strings. In viewerMain>viewerMain_OpeningFcn at 119 In gui_mainfcn at 220 In viewerMain at 42 Cell contents reference from a non-cell array object.

Error in getExperimentMetadata (line 9) dt = sheets{shind};

Error in viewerMain>menuLoadMetadata_Callback (line 1628) handles.experimentMetadata = getExperimentMetadata(handles.metadataPath);

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

Error in viewerMain (line 42) gui_mainfcn(gui_State, varargin{:});

Error in @(hObject,eventdata)viewerMain('menuLoadMetadata_Callback',hObject,eventdata,guidata(hObject))

Error in viewerMain>menuLoadData_Callback (line 213) callback(handles.listData, []);

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

Error in viewerMain (line 42) gui_mainfcn(gui_State, varargin{:});

Error in @(hObject,eventdata)viewerMain('menuLoadData_Callback',hObject,eventdata,guidata(hObject))

Error while evaluating uimenu Callback

clairelbromley commented 7 years ago

viewerMain Warning: Directory already exists. In viewerMain>viewerMain_OpeningFcn at 113 In gui_mainfcn at 220 In viewerMain at 42 Cell contents reference from a non-cell array object.

Error in getExperimentMetadata (line 9) dt = sheets{shind};

Error in viewerMain>menuLoadMetadata_Callback (line 1628) handles.experimentMetadata = getExperimentMetadata(handles.metadataPath);

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

Error in viewerMain (line 42) gui_mainfcn(gui_State, varargin{:});

Error in @(hObject,eventdata)viewerMain('menuLoadMetadata_Callback',hObject,eventdata,guidata(hObject))

Error in viewerMain>menuLoadData_Callback (line 213) callback(handles.listData, []);

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

Error in viewerMain (line 42) gui_mainfcn(gui_State, varargin{:});

Error in @(hObject,eventdata)viewerMain('menuLoadData_Callback',hObject,eventdata,guidata(hObject))

Error while evaluating uimenu Callback

clairelbromley commented 7 years ago

Still seem to be getting the same error with my new metadata - this error doesn't come up with the old metadata For the metadata formatting I understood that: 1) sheet names need to be dates 2) in the first column - format needs to be EC 3) Header row must be row 12- and as long as the names of the column headers aren't duplicated it doesn't matter what they are called

Have I got something wrong? Sorry, I haven't been able to figure it out I have sent you a link to the googledrive excel sheet - and the link below should also let you access it https://drive.google.com/file/d/0B5BMTPgxKjfcbmJNTWlCYURmWkE/view?usp=sharing

clairelbromley commented 7 years ago

This link should give you access to some processed data, which is just uploading now I have also emailed you with the link as well

https://drive.google.com/drive/folders/0B5BMTPgxKjfcVHI0S210Q0V0U0k?usp=sharing

dougkelly88 commented 7 years ago

The problem seems to originate with changes to how Excel is saving its .xlsx files. A workaround, if not a proper fix, is to save the metadata in Excel 5.0/95 format (https://uk.mathworks.com/matlabcentral/answers/100550-why-does-xlsread-return-errors-with-some-spreadsheets-on-non-windows-platforms-in-matlab-7-6-r2008a).

There was also a problem with a missing column on 090717 (line length).