Machine Vision

cancel
Showing results for 
Search instead for 
Did you mean: 

I'm green so please be kind.... The Imaq Find Circle Function returns an array of measurements (xy locations, area, etc). How can I save this data to an excel file?

Rico,

The output from the Find Circle function is an array of clusters, which you need to convert to a 2D array. The quickest way is autoindexing the array and converting each cluster to an array within the loop.

Once you have a 2D array, you can use "Write to Spreadsheet File" to write it to a tab delimited file, which can be read from Excel.

Bruce
Bruce Ammons
Ammons Engineering
0 Kudos
Message 2 of 3
(3,505 Views)
If you want to insert your data in an Excel worksheet:
- First convert your array of cluster into a 2D array as Bruce Ammonds has explained
- Then you should use the activeX commands of Excel to fill a worksheet of your data

But if you are 'green' this is not exactly a very easy approach.
Anyway, take a look at the example Write Table to Excel.vi in activeX examples of LV.

Good luck,

Alberto
0 Kudos
Message 3 of 3
(3,505 Views)