[DataViz] - Piechart2Val

Text Latest Grasshopper tooling experiment for data visualization. The script streams two sets of values (or more if desired) from an Excel spreadsheet via gHowl and maps data normalized on a two-dimensional piechart. First column values are distributed normalized along the inner chart to show ratios of the set. Additionally, the outer extrusion maps the second column normalized to a malleable minimum and maximum offset. Grab the GH definition and Excel sample file here and feel free to give me feedback in comments.


Text Note: this definition has been found to work with Grasshopper v0.80065 and gHowl r50 with the included OpenXMLSDK 2.0.

11 comments:

zsozso at: January 16, 2012 at 9:07 AM said...

mersi mult pentru def.

a-ngine at: January 17, 2012 at 1:30 AM said...

cu plăcere.

David Robles at: January 17, 2012 at 3:22 AM said...

hi, i cant make it work, could you share the excel file please? i have gh 8.0065, ghowl 0.49 and excel 2010

a-ngine at: January 17, 2012 at 3:37 AM said...

Hi David. Did you worked with gHowl before? It needs an installed version of open office on your machine. Additionally, I saved my table in '97-2003 compatibility mode.

Dong Wook, Kim at: January 17, 2012 at 6:34 AM said...

Hi, I installed gHowl latest version and opened your source file. then, I make a excel file like yours. set this file to path component. but it didn't work. so could you share a sample excel file?

a-ngine at: January 17, 2012 at 8:10 AM said...

from the gHowl grasshopper page: The spreadsheet components leverage the OpenXML engine. You must have OpenXMLSDKV2.msi installed in order for these components to work. These components read and write *.xlsx files.

However, you can download the excel sample file here http://www.box.com/s/s6vx5sanr9gvs2reyzsy

Anonymous at: January 17, 2012 at 5:41 PM said...

i installed OpenXMLSDKV2.msi give it a try with your excel file and ghowl 0.49 and 0.50 and it didnt work, i dont want to download openoffice just to try if this work
i have gh 0.80065 in rhino 4 sr9 and office 2010

a-ngine at: January 18, 2012 at 3:03 AM said...
This comment has been removed by the author.
a-ngine at: January 18, 2012 at 4:57 AM said...

Edit: download links are updated for the example files working with the latest versions of Grasshopper v0.80065 and gHowl r50 with the included OpenXMLSDK 2.0.

a-ngine at: January 18, 2012 at 4:58 AM said...

Shared, see above.

Anonymous at: July 30, 2012 at 7:00 AM said...

Hi,
great def!
I installed all required programs and uploads
and in fact is all working perfectly with your example file.
I have problems if I choose to save it (even without modify) and then set the new file path.
I'm saving in same format xlsx as the original.
openxmlsdk il installed. my version of gh is v0.80066 and ghowl is new...
what am I doing wrong?
thanks for you attention.
aldo

Post a Comment