xlsread with changing starting point

Question

Bart 2013-9-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/86914-xlsread-with-changing-starting-point

在 MATLAB Online 中打开

Hello all,

I've had some questions before, and everytime I did get an answer, so now I will try it again.

I'm using matlab to get some data out of a Excel document.

At the moment I'm using this code:

 dir_struct = dir('*.xlsx');
 for i = 1:numel(dir_struct)
  number(i) = str2double(dir_struct(i).name(10:(10+numel(dir_struct(i).name)-16))); % get the number-string out of the filename and turn it into a number (I have fixed the format there)
 end
 [revised_numbers, order] = sort(number);
 for i = 1:numel(order)
  [num, tekst, raw] = xlsread(dir_struct(order(i)).name,'MISC','B9:C16');

I've received this code in a question earlier. I wanted to use xlsread, but the excel file changes in name over time, so the part where the excel file is mentioned, is now numerical.

This code works fine for me.

My next problem has this code involved.

In the worksheet MISC, the matrix defined is now B9:C16. B9 is i=1, B10 is i=2 etc.

Now, the start of i=1 changes. At the moment, B9 is i=1. But in the future, B12 or B13 for example can be i=1.

What I want is the following code, if possible ofcourse.

Above the data that I want, there is always the text: "Simulation input".

Is it possible for matlab, to 'search' the column B for this text, and set that cell to i=1? So that the place of the start can be everywhere in column B.

I hope that this is clear for you to understand. If not, I will change it and I will try to make it more sence.

I would like to thank you in advance!

Greets, Bart

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Image Analyst 2013-9-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/86914-xlsread-with-changing-starting-point#answer_96458

You can use ismember() to search your column for particular text string. It will give you the row(s) where it was found. Then set them to 1.

9 个评论
显示 7更早的评论隐藏 7更早的评论

Bart 2013-9-25

在 MATLAB Online 中打开

You were right. I had two forms of txt and tekst.

This is the start of my code:

   dir_struct = dir('*.xlsx');
   for i = 1:numel(dir_struct)
    number(i) = str2double(dir_struct(i).name(10:(10+numel(dir_struct(i).name)-16)));
   end
   [revised_numbers, order] = sort(number);
   for i = 1:numel(order)
    [num, tekst, raw] = xlsread(dir_struct(order(i)).name,'Test TLB','B9:C88');
      columnB = tekst(:,2)
      simulationRow = find(ismember(columnB, 'Simulation input'))
      topRow = simulationRow+1;
i=1;
if strcmp(deblank(tekst(i,1)),'TLB.A1')
    TLB.A1 = num(i,1);
else
    disp('TLB.A1 is not specified correctly')
end
i=i+1;

When I run this, I get the following message:

columnB = 
      'TLB mass'
      'x coordinate TLB'
      'y coordinate TLB'
      'z coordinate TLB'
      'TLB short tail mass'
      'x coordinate short tail'
      'y coordinate short tail'
      'z coordinate short tail'
      'TLB long tail mass'
      'x coordinate long tail'
      'y coordinate long tail'
      'z coordinate long tail'
      ''

etc. This is indeed my excel file. next:

simulationRow =
      23
TLB.A1 is not specified correctly
TLB.Iyy1 is not specified correctly
TLB.Izz1 is not specified correctly
TLB.Ip1 is not specified correctly

etc.

Now, the Simpulation input tekst is at row 32. And my first data that i need to store in the workspace is TLB.A1. And this is on row 34.

So, the message that TLB.A1 is not specified correctly, has to do with the counting. But all the rest must not be shown, because I have a lot of these m-files, and I just need the data stored in the workspace, and I don't need the part that it is showing "ColumnB" and "Simulationrow =".

Do you understand what I mean? Or do I have to specify it better?

Thanks again for your help! I realy appreciate it!

Image Analyst 2013-9-25

Attaching your workbook to your message would make it easier if someone wants to try something. I can't get to it for several hours, if at all.

Bart 2013-9-25

Excuse me, here are my two files.

In excel, the data that I need are under Simulation input. I can only upload .xls, so i've changed that in my m-file also. I hope that it still works.

Thanks again. Greets, Bart

请先登录，再进行评论。