O
Oldsmelly
I have managed to load a black and white BMP image into a 248X740 cell Excel sheet. It's truly black and white - my whites are blanks and my blacks are "1"s.
If you look at it you see clusters of "1"s and I very much need help to do the following:
Run down each COLUMN in turn and as I come to a column of "1"s, add them up to get "Number" and, at the end of the cluster (signified by two consecutive blanks) take the address of the first blank, decrement the row number by "Number/2" (to get the CENTER of the cluster) and export that ADDRESS((Row-Number/2), Column) to another worksheet.
Continuing on, I reset "Number" to 0 and do the same for the remaining "1"s in that column and then move to the next column and do the same until I get to the very end.
Did your eyes glaze over? O goodness I hope somebody is still reading and can help me!
Is there anybody there who has loaded a BITMAP into Excel in code form? I should also very much like to hear from you.
PS this is a Machine Vision application.
If you look at it you see clusters of "1"s and I very much need help to do the following:
Run down each COLUMN in turn and as I come to a column of "1"s, add them up to get "Number" and, at the end of the cluster (signified by two consecutive blanks) take the address of the first blank, decrement the row number by "Number/2" (to get the CENTER of the cluster) and export that ADDRESS((Row-Number/2), Column) to another worksheet.
Continuing on, I reset "Number" to 0 and do the same for the remaining "1"s in that column and then move to the next column and do the same until I get to the very end.
Did your eyes glaze over? O goodness I hope somebody is still reading and can help me!
Is there anybody there who has loaded a BITMAP into Excel in code form? I should also very much like to hear from you.
PS this is a Machine Vision application.