Having trouble using the struct function, to structure my data set.
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
% 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',[]);
0 Kommentare
Antworten (1)
Walter Roberson
am 4 Apr. 2019
You have 'Times ' in the struct() call. Change it to 'Times' with no space.
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!