Sort/Export Mesh RGB Color to Excel

Grasshopper
, ,
1

All,

I’m trying to find a way to sort and export mesh color values to excel to match how I’ve sorted the mesh centerpoints by columns from left to right. This way I would have a list of their location and color that match how I read it on screen (see the below excel which is what I’m trying to achieve). Do I need to re-map the mesh faces somehow before going through the color process? I have been able to use the tag component successfully but can’t export that information. Any help would be greatly appreaciated!

2019-0531%20-%20Mesh%20Colors%20and%20Division
2019-0531%20-%20Mesh%20Colors%20and%20Division1358×736 101 KB
2019-0531%20-%20Excel%20Location
2019-0531%20-%20Excel%20Location697×824 159 KB

Mesh Color Study.3dm (8.6 MB)
Mesh Color Study.gh (695.9 KB)

2

image
image.png1094×380 63.9 KB

This outta do it…
MCol and Area are where you left off. Anything outside purple group is added by me.

3

Or this, similar to Will_Wang’s solution… :slight_smile:

Gh-Excel
Gh-Excel1524×655 82.8 KB

excel
excel798×612 148 KB

Mesh Color Study_RE.gh (708.1 KB)

4

@Will_Wang and @Jakinta thank you so much! These both work like a charm! Exactly what I needed!