treatmentListFromExcel.m
5e7cd9775936pezhman_excelExport

treatmentListFromExcel.m
View Options

			function [ treatmentList ] = treatmentListFromExcel( rawExcel )
			%TREATEMENT built the tratement structure array that identify the treatments
			% Detailed explanation goes here

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

			% define treatment structure array
			treatmentList = struct(...
			'treatmentList_id',[], ...
			'name' ,[], ...
			'description' ,[] ...
			);

			% define undefined treatment
			treatmentList(1).treatmentList_id = 1;
			treatmentList(1).name = 'undefined';
			treatmentList(1).description = 'The treatement is not defined yet';

			% define no treatment
			treatmentList(2).treatmentList_id = 2;
			treatmentList(2).name = 'none';
			treatmentList(2).description = 'No planed treatment, for healthy shoulders';

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

			% loop over rows of Excel table
			[rowN, ~] = size(rawExcel);
			treatmentList_id = 2;
			for row_idx = 2:rowN
			row = rawExcel(row_idx, :); % get the entire row
			treatmentName = row(treatmentName_col);
			treatmentName = treatmentName{1};
			if ~isempty(treatmentName) & ~isnan(treatmentName)
			sameTreatment = find(strcmp({treatmentList.name}, treatmentName)==1);
			if isempty(sameTreatment)
			treatmentList_id = treatmentList_id + 1;
			treatmentList_idx = treatmentList_id;
			treatmentList(treatmentList_idx).treatmentList_id = treatmentList_id;
			treatmentList(treatmentList_idx).name = treatmentName;
			treatmentList(treatmentList_idx).description = '';
			end
			end
			end

			fprintf('Done\n');

			end