read specific data from excel and create a vector ?
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
MUKESH KUMAR
am 31 Jul. 2017
Bearbeitet: MUKESH KUMAR
am 31 Jul. 2017
I have attached excel file
and to create a row vector 1*24 like
A1=[0 0 0 0 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 0 0 0 0 0 0 0 0 0];
A2=[0 0 0 0 0 0 0 0 0 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 0 0 0 0];
0 Kommentare
Akzeptierte Antwort
KSSV
am 31 Jul. 2017
Bearbeitet: KSSV
am 31 Jul. 2017
[num,txt,raw] = xlsread('app.xls') ;
A1 = zeros(1,24) ;
A1(num(1,2):num(1,3)) = num(1,1) ;
A2 = zeros(1,24) ;
A2(num(2,2):num(2,3)) = num(2,1) ;
2 Kommentare
Walter Roberson
am 31 Jul. 2017
The
clc; clear al ;
do not appear to be doing any useful work there ?
Weitere Antworten (1)
Walter Roberson
am 31 Jul. 2017
(This code is not tested)
[num, txt] = xlsread('app.xls');
nrow = size(num, 1);
use_cell = cell(nrow, 2);
for K = 1 : nrow
this_entry = zeros(1,24);
this_entry( num(K,2) : num(K,3)) = num(K,1);
use_cell{K,1} = txt{K,1};
use_cell{K,2} = this_entry;
end
use_struct = cell2struct(use_cell(:,1), use_cell(:,2));
Now there will be use_struct.a1 and use_struct.a2
0 Kommentare
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!