diff --git a/XLS_MySQL_DB/rawFromExcel.m b/XLS_MySQL_DB/rawFromExcel.m index 58664c0..d979e21 100644 --- a/XLS_MySQL_DB/rawFromExcel.m +++ b/XLS_MySQL_DB/rawFromExcel.m @@ -1,37 +1,36 @@ -function [ rawExcel ] = rawFromExcel() +function [ rawExcel ] = rawFromExcel(filename) %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 = '../../../../data/Excel/'; -filename = 'ShoulderDataBase.xlsx';filename = strcat(directory,filename); -sheet = 'sCase'; % 'Normal' & 'TSA' +%directory = '../../../../data/Excel/'; +%filename = 'ShoulderDataBase.xlsx';filename = strcat(directory,filename); +sheet = 'SCase'; % 'Normal' & 'TSA' xlRange = 'A1:CX999'; % range of column and row to be imported -[~,~,rawExcel] = xlsread(filename,sheet,xlRange); +[~,~,rawExcel] = xlsread(filename,sheet,xlRange,'basic'); -% get column of variables +% Get column of variables header = rawExcel(1,:); -sCase_id_col = find(strcmp([header],'sCase.id')); +SCase_id_col = find(strcmp([header],'SCase_ID')); -% delete rows without sCase) +% 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) + 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 - +end \ No newline at end of file