How can I use the struct function to struct my data set. And be able to perform a forloop . As show in my code
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
%% Loading Data
% 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;
data = struct('volume',[],'time ',[],'power',[]);
% for j = 1:length(sheets)-1 ;
% rawdata = xlsread([PathName, FileName],sheets{j+1});
% data(j).volume = rawdata(:,1);
% data(j).time = rawdata(:,2);
% data(j).power= rawdata(:,3);
0 Kommentare
Antworten (1)
Walter Roberson
am 3 Apr. 2019
Bearbeitet: Walter Roberson
am 4 Apr. 2019
%% Loading Data
% 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('volume',[],'time ',[],'power',[]);
for j = 1:numsheets-1 ;
rawdata = xlsread([PathName, FileName],sheets{j+1});
data(j).volume = rawdata(:,1);
data(j).time = rawdata(:,2);
data(j).power= rawdata(:,3);
end
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!