rawFromExcel.m
311dc6245431master

rawFromExcel.m
View Options

			function [ rawExcel ] = rawFromExcel()
			%RAWFROMEXCERL read the Excel file filename and output content in raw
			% Set the sheet and the range
			% Returns the raw data

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

			% Set Excel file name & directory
			directory = 'C:\Users\vmalfroy\Dropbox\shoulderDatabase\';
			filename = 'ShoulderDataBaseTest.xlsx';
			filename = strcat(directory,filename);
			sheet = 'Cases'; % 'Normal' & 'TSA'
			xlRange = 'A1:CM999'; % range of column and row to be imported

			[~,~,rawExcel] = xlsread(filename,sheet,xlRange);

			% get column of variables
			header = rawExcel(1,:);
			sCase_id_col = find(strcmp([header],'sCase.id'));

			% delete rows without sCase)
			row_idx = 2;
			[rowN, ~] = size(rawExcel);
			while row_idx <= rowN
			row = rawExcel(row_idx, :); % get the entire row
			sCase_id = row{sCase_id_col};
			if isnan(sCase_id)
			rawExcel(row_idx, :) = [];
			rowN = rowN - 1;
			else
			row_idx = row_idx + 1;
			end
			end

			fprintf('Done\n');

			end