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 view (last 30 days)
Show older comments
%% 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 Comments
Answers (1)
Walter Roberson
on 3 Apr 2019
Edited: Walter Roberson
on 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 Comments
See Also
Categories
Find more on Spreadsheets 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!