Extract each value from rows of excel sheet for 40 iterations

1 view (last 30 days)
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.

Accepted Answer

Walter Roberson
Walter Roberson on 1 Jul 2020
values = xlsread('Filename.xlsx');
for iteration = 1 : length(values)
K = values(iteration);
do something with K
end

More Answers (0)

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!