read specific data from excel and create a vector ?

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];

Answer 1

[KSSV]

[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) ;

[Walter Roberson]

The

clc; clear al ;

do not appear to be doing any useful work there ?

[MUKESH KUMAR]

thanks for solution if we have more than two rows like for 10 rows in excel then how can we use 'for loop' for it? I tried this A1 is B1{1} and A2 is B1{2} for two rows: [num,txt,raw] = xlsread('app.xls') ; for u = 1:2 for v = 1:2; B1{u}=zeros(1,24); B1{u}(num(v,2):num(v,3))= num(v,1); end end

Answer 2

[Walter Roberson]

(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