read specific data from excel and create a vector ?

Question

MUKESH KUMAR 2017-7-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/350888-read-specific-data-from-excel-and-create-a-vector

编辑： MUKESH KUMAR 2017-7-31

采纳的回答： KSSV

app.xls

在 MATLAB Online 中打开

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

KSSV 2017-7-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/350888-read-specific-data-from-excel-and-create-a-vector#answer_276139

编辑：KSSV 2017-7-31

在 MATLAB Online 中打开

[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 个评论
显示无隐藏无

Walter Roberson 2017-7-31

在 MATLAB Online 中打开

The

clc; clear al ;

do not appear to be doing any useful work there ?

MUKESH KUMAR 2017-7-31

编辑：MUKESH KUMAR 2017-7-31

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 2017-7-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/350888-read-specific-data-from-excel-and-create-a-vector#answer_276138

在 MATLAB Online 中打开

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