Extract each value from rows of excel sheet for 40 iterations
1 view (last 30 days)
Show older comments
Arif Adam Bin Mohd Nor
on 1 Jul 2020
Answered: Walter Roberson
on 1 Jul 2020
I have an excel file which consists of 40rows and 1 column. All values are numerical. The values are for parameter named 'K'. There will be 40 iterations to be processed. For example, iteration1, K=row1column1; For iteration2, K=row2column1. Could anyone please assist on how to import the data, extract every value at different rows for each iteration? Thank you.
0 Comments
Accepted Answer
Walter Roberson
on 1 Jul 2020
values = xlsread('Filename.xlsx');
for iteration = 1 : length(values)
K = values(iteration);
do something with K
end
0 Comments
More Answers (0)
See Also
Categories
Find more on Data Import from MATLAB 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!