Clear Filters
Clear Filters

Having trouble using the struct function, to structure my data set.

1 view (last 30 days)
% using the excel data
[FileName, PathName] = uigetfile('*.xlsx','Select Excel files to analyze:','MultiSelect','off');
[status, sheets] = xlsfinfo([PathName, FileName]);
summary_data = xlsread([PathName, FileName],sheets{1});
Volume = summary_data(:,1); % in mL
Time = summary_data(:,2); % in Seconds
Power = summary_data(:,3); % in watts;
numsheets = length(sheets);
data(numsheets-1) = struct('Volumes',[],'Times ',[],'Powers',[]);
for j = 1:numsheets-1 ;
rawdata = xlsread([PathName, FileName],sheets{j+1});
data(j).Volumes = rawdata(:,1);
data(j).Times = rawdata(:,2);
data(j).Powers= rawdata(:,3);
end
%% error I get After running
Error using struct
Invalid field name "Times "
Error in Lab1 (line 11)
data(numsheets-1) = struct('Volumes',[],'Times ',[],'Powers',[]);

Answers (1)

Walter Roberson
Walter Roberson on 4 Apr 2019
You have 'Times ' in the struct() call. Change it to 'Times' with no space.

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!