diagnosisListFromExcel.m
81a8e0e727dbpezhman_excelExport

diagnosisListFromExcel.m
View Options

			function [ diagnosisList ] = diagnosisListFromExcel( rawExcel )
			%DIAGNOSISLISTFROMEXCEL Summary of this function goes here
			% Detailed explanation goes here

			fprintf('\nGet diagnosisList from Excel... ');

			% define diagnosis structure array
			diagnosisList = struct(...
			'diagnosisList_id' ,[], ...
			'name' ,[], ...
			'description' ,[] ...
			);

			% set normal subnormaland diagnosis names
			diagnosisList(1).diagnosisList_id = 1;
			diagnosisList(1).name = 'normal';
			diagnosisList(1).description = 'fully normal';

			diagnosisList(2).diagnosisList_id = 2;
			diagnosisList(2).name = 'subnormal';
			diagnosisList(2).description = 'no OA but small abnormalities';

			% get column of variables
			header = rawExcel(1,:);
			diagnosisName_col = find(strcmp([header],'diagnosis.name'));

			% loop over rows of Excel table
			[rowN, ~] = size(rawExcel);
			diagnosisList_id = 2;
			for row_idx = 2:rowN
			row = rawExcel(row_idx, :); % get the entire row
			diagnosisName = row(diagnosisName_col);
			diagnosisName = diagnosisName{1};
			if ~isempty(diagnosisName) & ~isnan(diagnosisName)
			sameDiagnosis = find(strcmp({diagnosisList.name}, diagnosisName)==1);
			% check if this diagnosis is already present in the array
			if isempty(sameDiagnosis)
			% add this diagnosis to the array
			diagnosisList_id = diagnosisList_id + 1;
			diagnosisList_idx = diagnosisList_id;
			diagnosisList(diagnosisList_idx).diagnosisList_id = diagnosisList_id;
			diagnosisList(diagnosisList_idx).name = diagnosisName;
			diagnosisList(diagnosisList_idx).description = '';
			end
			end
			end

			fprintf('Done\n');

			end