How can I use the struct function to struct my data set. And be able to perform a forloop . As show in my code
조회 수: 2 (최근 30일)
이전 댓글 표시
%% 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
답변 (1개)
Walter Roberson
2019년 4월 3일
편집: Walter Roberson
2019년 4월 4일
%% 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
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!