Effacer les filtres
Effacer les filtres

Extract each value from rows of excel sheet for 40 iterations

1 vue (au cours des 30 derniers jours)
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.

Réponse acceptée

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

Plus de réponses (0)

Catégories

En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by