Having trouble using the struct function, to structure my data set.
Show older comments
% 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
on 4 Apr 2019
0 votes
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
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!