Grasshopper/ Excel (Read, Write, Chart)

I have posted a download for a series of beta grasshopper vb components which allow for live interaction with excel.

The components both read and write from excel and have optional inputs to transfer formatting parameters, color, size, etc. from Grasshopper to Excel. Additionally Excel Charts can be produced directly from Grasshopper with a series of custom formatting options.

You can find the file at: http://neoarchaic.net/2011/01/gh-excel-suite/

It is based of the work by Damian Alamar of www.liquidtectonics.com

I hope you enjoy, find it useful, and look forward to any feedback, suggestions.

Replies to This Discussion

Permalink Reply by Mateusz Zwierzycki on February 4, 2011 at 2:45am

I can 100% agree with you about it. David, please publish ultra-beta.

Permalink Reply by Danny Boyes on February 4, 2011 at 3:49am

http://www.grasshopper3d.com/forum/topics/live-stream-to-openoffice

Permalink Reply by Gabe Krause on February 4, 2011 at 11:53am

okay, okay, I can see how it would be nice to have the formatting capabilities. But the basic functions have to be nailed down first.

I've attached a definition that can be used to test your 'streaming from excel' VB components. If the output doesn't match the input, something in the script isn't right. As of GH-Excel_v0-03, it doesn't work.

In the attached definition, at the far right, I have included corrected VB scripts that do seem to work as expected.

I sadly don't know VB scripting at all; but I was able to find that the problem seems to be in the function (or whatever it is) "excelSheet.Cells(X,Y)." It only works right when they're backwards "excelSheet.Cells(Y,X)" (That is if we assume that most people order X before Y).

I don't know if that's a function you wrote or if it's from a library, but it seems to me like it's backwards and is the reason your script wasn't working correctly.

Attachments:

GH-Excel_v0-03_TEST.ghx, 674 KB

Permalink Reply by David Mans on February 4, 2011 at 12:14pm

Gabe,

Thank you for pointing that out.

That probably came about when correcting the reversal of the write to excel functions outputs. Ill check through all the possible combinations of inputs and outputs tonight and make sure they are all coordinated for the XL and OOo functions.

Permalink Reply by David Mans on February 4, 2011 at 7:44pm

GH-OOo V 0-001 has been released and repaired the following consistency errors

Now X always references the column position and Y the rows. Additionally if "byColumn" inputs are true all components will now either read or write by stepping down a column.

Permalink Reply by Francisco Lara on September 28, 2011 at 1:00pm