Extract each value from rows of excel sheet for 40 iterations
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Arif Adam Bin Mohd Nor
am 1 Jul. 2020
Beantwortet: Walter Roberson
am 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 Kommentare
Akzeptierte Antwort
Walter Roberson
am 1 Jul. 2020
values = xlsread('Filename.xlsx');
for iteration = 1 : length(values)
K = values(iteration);
do something with K
end
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!