Re : put coordinate ROI rectangle in Excel

[Gerday.M]

Hi everybody,

I`m working on one system to track one fly. I`m able to follow the fly, make a graph XY with his moving and put in one matrix the coordonate XY for each frame of the video.

But now I have to draw with labview several rectangles and I would like to obtain their coordinate on Excel.

But I found nothing, I`m working on it for a long time... I searched a lot here but didn`t find anything which looks like my problem (I`m a little desperate 🙂 ).


1) My first problem is like I said before. I know to draw my rectangles but I would like to extract the data to draw back the rectangle on one XYgraph on labview and for the best make the same on Excel.

2) It`s not the most important at this moment but like I`m here, I ask all my questions

3) After I will mixe the data about the flies and the area. And I think it will be easier with matlab. It`s why I try to have all the data on Excel. But this problem is for later. ^^


I hope I was clear

thanks a lot for your answer

Sincerely
Maxime

[Gerday.M]

After sleeping one night on my problem, I see more clear.

But I still have some problem.....

After to draw my rectangle (green on the picture) I have also the coordinate about this rectangle written in " array of rectangle".
I`m trying to export this data to put in one array or for the best put those data on excel, but when I tried to export the data (cluster) only the left is good but for the rest is all the time 0.... 
Why I don`t understand....

Sincerely
Maxime 

[Bozhidar]

Hi Maxime,

First of all to make sure, we are on the same track. The problem you want to solve is the logging to Excel? If so, I really cannot see in your code, where are you logging the data. 

What functions did you use to log the data to Excel? Can you provide your code? 

If I didn't understand the issue well, let me know and elaborate a bit more on the problem you want to solve. Thanks!

Regards,

Bozhidar

[Gerday.M]

Hi,

In fact, I resolved almost all of my problem.

I join my code, the excel file and on picture about what i`m drawing at this reply. 

Now I have an other problem.........

I have to draw the two others arms of my "Y"...... but I use for this one rotation rectangle..... and Labview send to excel the data like if the rectangle was straight and one angel of rotation.

And for me it`s a problem, I add to one excel about this case.

Anyway, I`m still searching, I found one exemple of this forum But it is not very easy to adapt to my code.
If we have the solution that`s Welcome.

thanks your for your reply

Maxime

PS: I can`t put the excel in annexe. I put just on the bottom two pictures

[Bozhidar]

Hi again Maxime,

Thanks for clarifying! 

What do you want to do with the rotation angle and why it is a problem that you get it once? 

Best,

Bozhidar

[Gerday.M]

So to resume you the situation, I have to track one fly in this kind of labyrinth (called Y-Maze).

So my idea was to track first the fly, write on Excel all of his coordinnate during the experiment.

And in the second time, find the coordinnate of the Y-Maze and write this on Excel.

And Finally to use matlab to compare, if my fly was in the arm A, B or C in the Labyrinth. To know his move, the speed, how many time the fly stay in one arm, etc...... (this kind of information)


But I found the solution. I add in my reply if you want to check.
(maybe the code it`s very beautiful and clear but I`m only a debutant, so I try to improve myself)

Anyway, Probably I would have a lot of others questions later, But I`m going to work on it before.

I don`t want to flood the forum

Thanks you a lot for patience and your reply

Best regard

Maxime