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.

Categories

Find more on Structures in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!